Hi,
Weโve heard feedback that many would like to have additional capabilities to filter data in a chart or on a dashboard. Tell us what you think of this idea: filter data that's in a chart or on a dashboard using a dynamic date range like 'last 6 months' or 'year to date'.
For example, letโs assume that you have a dashboard showing data that gets updated every day with new data. As a user, you want to look back at this data over various time intervals: show me the last 7 days, show me the last 30 days, show me the last 2 yearsโฆ Doing this in the Flow is easy enoughโ maybe you add a time-based filter to a Prepare, update it depending on the date range you want, and then rebuild the Flow. However, your stakeholders who use this dashboard canโt do that and so youโve built multiple copies of your dashboard, one for each lookback period they want to see.
With the ability to apply relative date range filters to a chart or dashboard, youโd add your date field to the filter pane and define your lookback/lookforward range that will be applied as a filter, let's say 'last 30 days'. The range updates itself automatically over time so that youโre always seeing the last 30 days of data in your charts, no additional rework needed. If your stakeholders want to change the settings and see the last 60 days they can do that without asking you to make a manual change in the Flow.
If youโre reading this post and think this would be a great capability to add to DSS charts, be sure to upvote it! ( โฌ๏ธ = โyes, please!โ ). Feel free to leave a comment in the discussion about how this capability would help you or your team.
Cheers,
Ashley