Conditional Formatting - table MoM
Hello,
I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as red since there was a drop off) Photo attached of the table's current header set up:
The color rule conditions don't seem to be able to compare to other values in the table so I assume I need a beast mode I'm just not sure how to go about it.
Best Answer
-
You can't directly.
- You could change your measure to be "change from prior month" instead of the raw value.
- You could have that "change from prior month" as a separate value in the pivot table, and color-code that
- A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:
- Here's another example I posted that I think looks a little nicer:
https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
You can't directly.
- You could change your measure to be "change from prior month" instead of the raw value.
- You could have that "change from prior month" as a separate value in the pivot table, and color-code that
- A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:
- Here's another example I posted that I think looks a little nicer:
https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive