One controle for 3 dates

Question & Answer
, ,
1

Hi,

I have a year-to-date data volume analysis to perform. To do this, I created a histogram with the year on the x-axis and the quantity on the y-axis. To obtain the data for each year, I used a filter with date ranges. The first filter includes data between 1/1/2021 and 730 days ago (2 years), the second filter includes data between 1/1/2022 and 365 days ago, and the last filter includes data between 1/1/2023 and today. My question is, is there a way to have a control that, when selecting today’s date, also automatically adjusts the other two dates to be 365 days ago and 730 days ago respectively?

Thanks,
Killian

2

I don’t know if this is possible. Have you looked into cascading filters for this problem?

2 Likes