This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?