Hi all,
I'm building a dashboard with Cognos Analytics and I have an issue with color scales. I attached a screenshot.
What I want to achieve:
1. Custom boundaries for the color buckets. This is evident for the table, but not for the map.
2. Fixed boundaries for the color buckets. I ticked 'maintain axis scale', but the boundaries still change when I filter the tab or use the data player.
3. Consistent colors and boundaries between the table and map.
Ideas so far:
- Creating a custom color palette for the map.
- Introducing a category variable (https://it.toolbox.com/question/how-to-change-heat-map-colours-in-cognos-091514). This could help a bit, but the issue would still persist if one or more categories are not present after filtering.
I hope you have some more ideas or could help me out!
Greetings from The Netherlands
(https://i.ibb.co/QvmcH2V/Screenshot-2020-05-08-Dashboard-Collisions.png) (https://i.ibb.co/5hc9jN3/Screenshot-2020-05-08-Dashboard-Collisions.png)