How can I have daily information reflect on the dashboard?


Each day they want to enter new data to have a running history. I have a form created. My metric widgets, however, pull from the ROW above. I don't want to update the widget each day. I can do this with reports, but they really want the metric widget look. Is there anyway?

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓


    Try this for your ED Census Summary Field

    =INDEX([ED Census]:[ED Census], MATCH([Field 1]#, [Date Submitted]:[Date Submitted], 0))

    You should be able to copy this formula directly into your summary field.

    Does this work for you?