Comparative gauge and filters?
I am trying to build a gauge that shows a % for the currently selected company value in comparison to the % for the community as a whole.
The problem i run into is that as soon as I filter the card to the current company, I no longer have the entire community's data to compare against?
I don't see any way to just filter for 1 element of the data, but not the other.
How have others solved this problem?
thanks in advance.