One controle for 3 dates


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?


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