Trying to compare two charts/maps of current selections vs. excluded selections
I want to have two maps side by side to compare. Map 1 would update with current selections, while map 2 would do the complete opposite and display data where selections are excluded (and this would keep going for multiple selections in the app).
So e.g.
If I wanted to compare income of counties with avg median income>60,000. Map 1 would show data for counties with income > 60,000 and map 2 would auto update to show data for counties with median <60,000. I can write a set analysis but I'd have to do that for every type of data I wanted to compare. Is there something a way to do this where map 2 would show excluded selections automatically?
How about when I select other fields though? This would only work on 'sales' correct? I want the maps to update automatically based on all possible selections.
Hi, that was an example, using a field Sales that I invented just to make the example, the important thing is that you can use the set analysis "{1-$}" to use the excluded values.
Thanks, I understand set analysis and how to use it but was wondering a different method where I didn't have to write a set analysis for every field and can just update automatically based on user selections.
You don't have to write this for every field - just a {1-$} in every expression where you want to only show the excluded values. This isn't specific to a field.
