Map Chart diverging by Column, variable or calculated value

Lass
Member
Use case: Build a map where the provinces are red whenever their performance in percentage is lower than the country average performance and green otherwise. Right now this is impossible.
At the moment the ability to set a green or red visual clue is determined by either The mean, the median, zero or a fix number set un 'Manual'.
The problem is that whenever we are dealing with percentages or any kind of fraction the mean of the country is diferent that the mean of the values due to algebra.
I'd love to be able to reference a field, a formulae or something that gives me the option to customize the zero of the diverging color map.
Tagged:
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 665 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 488 APIs & Domo Developer
- 97 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive