I have created 3 sheets in a dashboard, and I want the user to see last 7 days worth of data when they open the dashboard.
I have created a Date and Time Range Between filter, but when I change the data from the date selector the filter is not getting reset when I reload the dashboard.
I created parameter, but I want to create a cascading filter. Each sheet is linked to a type of test validation and then we can select the runID which only belong to the test validation on the sheet. I want to do this on the date range as well, so for a test validation, if the user selects a date range then the run ID’s which belong to that test validation and are between the data range should be displayed in the drop down. So when I created a parameter for start and end date, I’m unable to add the date filter to the run ID drop down using the Control Option however a normal date range filter is showing up on the Control Option of run ID drop down in relevant filed option.
Any suggestion on how can I load the last 7 days data when any user lands on the dashboard.
What type of date filter are you using? I would start with trying out the relative date filter and seeing if that works. You can set it up like the screenshot below:
I think it would be easier to help find the solution if you created an example. Could you try making an arena example of the problem you are trying to solve?
Since we have not heard from you in some time I am going to archive this post.
If you are still running into this issue and need more help please post a new question at the top of the community. In your new post, you can link back to this question.
