I want to highlight where 2 (or more but will start with 2) feature sets intercept the most (based on feature count) on a map.
For example, I have a layer with features with a unique value attribute (entity identifier).
The first entity is found in Chicago (100 features), San Francisco (300 features), and New your (500 features).
The second entity is found in Chicago (50 features), San Francisco (300 features) and New York (100 features).
In this example, I'd like to see San Francisco red hot (0%), Chicago warm (66.67%), and New York cool (133.33%) - using percentage difference (or other calculation more fitting this example).
Also, as I zoom into any area, the heat map should persist to highlight where there is most/least overlap.
Is this possible? I tried looking at various renderers but have not found the one that quite fits this scenario. Maybe there is one that just has to be setup correctly?
Any info appreciated. Thanks!