Can I show positive (instead of negative) numbers in red?

Alex_K · 2023-11-29T21:25:45+00:00

There was an error rendering this rich post.

I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.

Is there a way for me to have only one row be opposite of normal with positive numbers in red?

Find more posts tagged with

Analyzer

Visualization

Formatting

Color

Accepted answers

MichelleH

@Alex_K You can do this by adding HTML to your metric in a beast mode like this:

case 
  when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>')
  else concat(`Sales`,'')
end

Here is a knowledge base article on how that works: https://domo-support.domo.com/s/article/360043430033?language=en_US

pauljames

@Alex_K Hey there! Have you tried this?

MarkSnodgrass

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.

All comments

GrantSmith

Have you looked into utilizing color rules so that if it's < 0 it's green and > 0 it's red?

https://domo-support.domo.com/s/article/360043428813?language=en_US