I’m currently working on optimizing my dashboard, and I’m looking for insights on how to automate date range updates for reports.
My dashboard is set up to display data from for example, 10/8 to 10/14 (Sat to Sun), and I’d like to streamline the process of updating the date range each week. Ideally, I want the reports to automatically reflect the current week’s data without manual intervention.
Also, imagine you choose any day of the week in any given month. Once you select that date, the dashboard should showcase all the data related to that entire week. For instance, if you pick the date 10/11/2023, the dashboard should display all the corresponding data from 10/09/2023 to 10/13/2023.
You can choose the date range for the dashboard automatically. If you choose ast week it will show what you want by default. So as long as the week is not over you will see the previous week’s data. This will override the report defaults on that dashboard. However, if the report was built without that filter, it will retain its own default if you open the individual report.
As an example, if a web analytics report was originally setup to show the last 30 days, but you set the dashboard to show last week, the dashboard will show last week. But if the user goes directly to the report instead of going through the dashboard they will see last 30 days instead of last week.
Absolutely, there’s an additional requirement now. Imagine you choose any day of the week in any given month. Once you select that date, the dashboard should showcase all the data related to that entire week. For instance, if you pick the date 10/11/2023, the dashboard should display all the corresponding data from 10/09/2023 to 10/13/2023.