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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive