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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive