"Colors" shows limited options based on Beast Mode
I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile.
The Beast Mode is as follows:
In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.
But when I go to add a Color rule, it only gives me two options. Is this a bug?
Best Answer
-
The color rules may not recognize the aggregated formulas in the pivot table.
For example, if each point in your dataset ranks A or B, then the color rules will only show these options, even if the aggregation formula in the pivot table ranks some groups of data points as C and D, in addition to some groups that are ranked as A and B.
If this is the source of the problem, the solution is quite simple:
Instead of using a beastmode to calculate the aggregated table, simply do the calculation in Magic ETL and output the table in pivoted format from the beginning. This will ensure that each data point is ranked correctly on the source dataset and does not rely on the aggregated formulas in the pivot table for the color rules.
0
Answers
-
Hey W,
Could you share a screenshot of your full analyzer page?
If a filter is applied that excludes categories C and D, they will not appear as an option for color rules.
Another thing that could cause this is if categories C and D are not present when the calculation runs. i.e. if none of your data points are less than or equal to .59
0 -
Hi @nmizzell, I would prefer not to share the full page due to company metrics. However, in the preview, all 46 Districts are present and all of them have Tiers A-D as the Beast Mode calculates.
1-11 are showing D
12-23 are showing C
24-34 are showing B
35-46 are showing A
In my original post, the screenshot shows Tiers C and D present in the preview, but only A and B are showing up in the Color Rule list. I do not believe a filter is affecting this.
0 -
The color rules may not recognize the aggregated formulas in the pivot table.
For example, if each point in your dataset ranks A or B, then the color rules will only show these options, even if the aggregation formula in the pivot table ranks some groups of data points as C and D, in addition to some groups that are ranked as A and B.
If this is the source of the problem, the solution is quite simple:
Instead of using a beastmode to calculate the aggregated table, simply do the calculation in Magic ETL and output the table in pivoted format from the beginning. This will ensure that each data point is ranked correctly on the source dataset and does not rely on the aggregated formulas in the pivot table for the color rules.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive