Help In Domo

Options
M_A
M_A Member

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

  • david_cunningham
    edited May 31 Answer ✓
    Options

    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! ✔️**

Answers

  • david_cunningham
    edited May 31 Answer ✓
    Options

    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! ✔️**