Indicator in Pivot Table

Hi,

Is there a way to add an indicator, like you can in excel, to a table in DOMO? (For example, Like the green and red dots in the excel picture below)

Best Answer

  • marcel_luthi
    marcel_luthi Coach
    edited December 2023 Answer ✓

    You can simulate the behavior by having a text field be shown rather than a numeric value. Lets say you that percentage comes from doing Col1/Col2 just as an example. Then you'll have a beast mode that Looks something like:

    CONCAT(CASE WHEN SUM(`Col1`)/SUM(`Col2`) > 0 THEN '🔴' ELSE '🟢' END, ROUND(100*SUM(`Col1`)/SUM(`Col2`),2), '%')
    

    The reason why we're using a SUM here, is so that this will also work for total and subtotal rows. Then you'll use this beast mode as the column to display.

Answers

  • marcel_luthi
    marcel_luthi Coach
    edited December 2023 Answer ✓

    You can simulate the behavior by having a text field be shown rather than a numeric value. Lets say you that percentage comes from doing Col1/Col2 just as an example. Then you'll have a beast mode that Looks something like:

    CONCAT(CASE WHEN SUM(`Col1`)/SUM(`Col2`) > 0 THEN '🔴' ELSE '🟢' END, ROUND(100*SUM(`Col1`)/SUM(`Col2`),2), '%')
    

    The reason why we're using a SUM here, is so that this will also work for total and subtotal rows. Then you'll use this beast mode as the column to display.