I have a dataset that looks something like this:
I want to build a card that shows the Q over Q difference and allow the user to filter by Region. But I also need to either have the filter always have a value, i.e., not allow the user to unselect all values, or show the difference between the 'Global' values when none of the region values are selected.
For example. If I filter on 'AMER' I should see and the card I built does show this:
This is just Q2 - Q1 or 80.4 - 78.2 This works fine. And if I select 'Global' in my filter I see this:
...again this works fine and is what it should be, 79.2 - 79.8
HOWEVER, if the user clicks on 'Global' once again and therefore unselects all values on the filter the results go to this:
...which is the sum of all Q2 values minus the sum of all Q1 values. The user may think by unselecting all filtered Region values they will see the 'Global' value. However, they see the sum of all of the values which is incorrect and these scores are not additive.
So, is there a way to force the filter to have a value?
Or is there another way of going about this?
Thank you.