I have a problem with multi-filtering in my dashboard. At the top, I have a “month” filter, which helps the viewer set the month of the year statistics he will be looking; that’s the main filter, but on every graphic we have another filter, which depending on the selected month, shows the week number to choose. I will add some photos to make this easier to understand:
That was the month filter, now, for the graphics filter, I chose the month “May” which is Mayo in spanish. These are the weeks that the other filter is showing:
There we can see that shows the number of every week and we can choose the one that we want to look at. I will choose the week number 20 to show the problem.
So there I chose week 20. The problem starts when I leave that 20 chosen, and I change the month of the main filter. Let’s say I choose April, which is Abril in spanish, this is what happens:
It shows a graphic without any data, and that happens because of this:
Even though I changed the month, it keeps showing the week 20, which is not in the month April, and that makes the dashboard fail while another person is watching it.
How can I solve this problem? Is there a way to program or put an action that makes the second filter delete the option we chose when we change an option from the main filter?
Thanks!