I have an app I need to run on my own gallery server, where a user selects a start date, and end date, and can also select from a list of model types, which represents claims and sums the total number based on the state location. I want it to create a US states map with 3 colors- Green(high), White(normal), Red(low), divided equally into thirds based on the state totals. The problem I am having is how to show 3 colors that represent the total counts when the ranges will always change because of the users criteria selection?
For example, if a user selects 1 week, and only 2 model types, I may get a count of-
But if a user selects a larger time frame, like the last 3 months, I would get a much larger count of-
Is there any way to somehow get the count range to always be in thirds(for each of the 3 colors), even thought the count ranges will be completely different?
Hi @robert_derubeis, could you do something like the below? I basically used a tile tool and divided it into three groups with each group being equal in the sum. Then based on the group number, I either coded it red, yellow, or green in the next formula tool.
That is exactly what I did, but it is not what I need because the values of the "count" field can be completely different based on the user selection. The end result I want is a 3 color thematic map(high/red, medium/white, low/green), based on the total "count" value for each area. By using the tile tool and specifying - equal sum with 3 tiles, it gives an incorrect map depiction when the user values are, for example, the first 30 rows = 1, the next 10 rows = 2, the last row = 3(based on the 3 equal groups tile tool). I would need a legend range of 1=green, 2=white, 3 or more=red.
But if the user selection returns something like in my example, where the count is between 5 to 205, then I would need a completely different legend range, more like
5 to 50=green
51 to 100=white
100 or more= red
but I don't know what the range will be until after the user makes their selections?