Rolling updates - can I automate data selection for dashboard?

22Wordsmith

I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes from a set of metrics sheets that have to be updated each cycle.

Paul Newcome

It could be possible depending on your exact needs and how you are collecting data. Are you able to provide some screenshots for context and more details? How exactly do you determine the "current"?

22Wordsmith

Hi Paul

My Reporting Period comes from a drop-down list in the base sheet. For example: March 2025 - May 2025 (400 days). There are values for 100 days, 200 days, 300 days. There's also one value called UNASSIGNED.

Reporting Period is used in my metrics sheets for a formula like the following:
=COUNTIFS({ReportM},"March 2025 - May 2025 (400 days)",{ClearM},=1,{ThemesM},Metric@row)

Every 100 days I need to create a new metric sheet with updated reference.

What I am hoping is that there is a way to have the formula look for a "current" period. It would probably have to do so with reference to "Today", if that is possible.

These metrics feed into my dashboards.

Paul Newcome

Are you able to provide some screenshots for context?