Card Color Options
Curious if anyone has a workaround for highlighting the top x rows of a table when creating a card. The color rule options are all based on the value of a column, but I just need to highlight the top 2 rows on the chart (as it is sorted on a measure column greatest to smallest)
Essentially here is what it would look like (and I would want the west and north highlighted in this example, but the numbers will change, so always Rank 1 and 2):
Rank | Area | Metric |
---|---|---|
1 | West | 10 |
2 | North | 7 |
3 | East | 5 |
4 | South | 2 |
Any help would be greatly appreciated.
Best Answer
-
You could set the color rule based on rank. So when Rank <= 2 then color
If I solved your problem, please select "yes" above
0
Answers
-
You could set the color rule based on rank. So when Rank <= 2 then color
If I solved your problem, please select "yes" above
0 -
Thank you, how do I do that. Are you saying beastmode formulas can color rows? I didn't think there was a rank function, so the first column is simply the same data as the last column, just displayed as "ranked highest to lowest".
0 -
You can use a rank & window tile in your ETL to create a rank or create a rank with the following beastmode:
RANK(Metric
) OVER (order byMetric
DESC)This will create a dynamic rank value that you can use to assign your color rule.
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive