Limit Date Filter to data in dataset

Question & Answer
,
1

Hi,

I visualize data from a system in a dashboard. Because the system sends the status every 15 milliseconds, I limit the queried data to the last 20 days and load it daily into Spice. Users can select a daterange in the dashboard, also to days that are not present in the data, which results in confusion.

So my question is: Can I limit the Filter to dates present in the data. I want to achieve that users can only select days that are present in the dataset and the rest being grayed out.

Thanks a lot for any suggestions!

2

Hi @fabian.altendorfer , Thanks for the question & Welcome to the community.

Since you’re loading the last 20 days of data, you can set up a relative date filter

  • Set the range to “Last 20 days”

This will automatically adjust as new data is loaded and prevent users from selecting dates outside your data range. Hope this helps!

1 Like
3

Hey @harpson,

many thanks! This helped a lot!

1 Like