I need your help with something: I’m trying to filter a value considering a previous value that a filter would have (this previous value would be selected in a dropdown filter by the client).
I want the client filter the month of the year to see in a KPI viz the number of tickets that have been solved in that specific month. And at the same time, I want to filter automatically that specific month and the month before to that one , just to show the sum of the the tickets solved in both months.
Number of tickets by month:
What I’d like to see?
1-Client filter MARCH using the dropdown filter, the 1st viz should show 20
2-Automatically, I want another botton could filter MARCH and FEBRUARY (month before to the selected), so the 2nd viz should show 30