Indicator in Pivot Table

ColinHaze

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)

marcel_luthi

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.

marcel_luthi

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.