Help In Domo

M_A

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.

david_cunningham

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

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.