Help In Domo

I have three months attendance data including current month, and I want to check the last two months leave percentage of an employee. I got it by using the Pivot but here how can I highlight those employees who has taken more than 20% leaves in both the months.
Best Answer
-
Out of the box, Domo has color rules for single columns. If you're wanting to compare 2 columns and trigger a color rule, you'll want to set up a beast mode, and then key your color rule off of that. Something like
CASE WHEN "Total Leave % Current Month" > 0.2 AND "Total Leave % Current Month-1" > 0.2 then "Last 2 Month > 20%" end
The above is psuedo-code, but you can use it as a general structure.
You can then use the output of your beast mode to drive your color rule. You can choose to apply the color rule to the entire row, or just the column.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1
Answers
-
Out of the box, Domo has color rules for single columns. If you're wanting to compare 2 columns and trigger a color rule, you'll want to set up a beast mode, and then key your color rule off of that. Something like
CASE WHEN "Total Leave % Current Month" > 0.2 AND "Total Leave % Current Month-1" > 0.2 then "Last 2 Month > 20%" end
The above is psuedo-code, but you can use it as a general structure.
You can then use the output of your beast mode to drive your color rule. You can choose to apply the color rule to the entire row, or just the column.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive