Forum Discussion
Two issues: Relationship between tables and shape map dynamic fill colors. Need Help.
The Shape Map is a preview item, and I guess there are some bugs with it still as there is not a function option on the fill colors. I did find that if I create the map as a filled map with a function for the fill colors, I can THEN change it to a Shape Map and the function option will remain. However, it doesn't work if you create the Shape Map, change it to a Filled Map, use the function option and then change it back to a Shape Map. You have to start it as a Shape Map.
On the first question, I need to be able to calculate the ratio of issue volume by the average active accounts for a time period, in year increments. The date filter will be by year.
On the second question, I want a map that shows by color fill what states have the highest ratio of issue volume to active accounts for a time period. The shape map does not have the function/fx capability, but I think that there could be a way to create a measure that dynamically forces the "ranking" of issue volume to active accounts ratio to a normalized number (between 1 and 2 maybe), and then use that measure as the color fill value. So out of 50 states, no matter what filters are selected they would have a ratio normalized between the numbers 1 and 2 (1.1, 1.2, 1.6, etc.) and then I can select 1 as the minimum color value, 1.5 as the center and 2 as the maximum.
The Shape Map is a preview item, and I guess there are some bugs with it still as there is not a function option on the fill colors. I did find that if I create the map as a filled map with a function for the fill colors, I can THEN change it to a Shape Map and the function option will remain. However, it doesn't work if you create the Shape Map, change it to a Filled Map, use the function option and then change it back to a Shape Map. You have to start it as a Shape Map.