I have an application with its data joined onto a calendar table, for obtaining useful information like Year, Quarter, Month, Day, IsHoliday, IsWeekend, etc.
I am creating a line chart with list boxes displayed above for the Year, Quarter, Month, and Day, so that end users can filter their results accordingly.
Is there any way to set up an action to trigger another selection, so for instance, if a user selects the year 2019 and the month "May", it will also automatically select the "Q2" quarter. Currently, the selectable results leaves only Q2 clickable, but I want it to automatically select it as well, so that if a user removes the month selection, it will have the next hierarchical selected level displayed (Q2 in 2019).
Rather nit-picky, but something that I was wondering if it could be done. Any suggestions?