Color Coding or conditional formatting in DOMO?

gbrown

I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds.

Thanks,

Garrett

MarkSnodgrass

If you are using a mega table, you can create beast modes that color the numbers like this:

CASE WHEN budget > actual then concat('<div style="color: #ff0000">',`budget`,'</div>')

else

concat('<div style="color: #00ff00">',`budget`,'</div>')

end

This would turn the budget red if it is higher, otherwise it will be green.

MarkSnodgrass

Try switching to the HTML table chart type and see if that works.

MarkSnodgrass

You can construct the format through some elaborate beast mode syntax, but it will still be viewed as text. If you search the community for beast mode formatting, you should see some examples. You could add a round function to eliminate pennies very easily, but the commas and $ signs require an elaborate beast mode.

GrantSmith

Here are a few posts on beast modes that may help you:

https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting

https://community-forums.domo.com/main/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number

https://community-forums.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting

GrantSmith

You can replace the FLOOR(SUM(`random_number`)) on line 11 in the example with the beast mode that will format the value with commas. You can refer to the Number Formatting link I sent earlier.

MarkSnodgrass

If you are using a mega table, you can create beast modes that color the numbers like this:

CASE WHEN budget > actual then concat('<div style="color: #ff0000">',`budget`,'</div>')

else

concat('<div style="color: #00ff00">',`budget`,'</div>')

end

This would turn the budget red if it is higher, otherwise it will be green.

gbrown

Thank you for this. This looks like this will be able to help. In the beastmode what do I need to change? It seems to be brining the budget over but not the color.

CASE WHEN SUM(Budget) > SUM(Amount) then concat('',SUM(Budget),'')

else

concat('',SUM(Budget),'')

end

gbrown

MarkSnodgrass

Try switching to the HTML table chart type and see if that works.

gbrown

Great that worked! One last thing is it will not format to currency I am assuming because it comes in as a text. Is there work around this or is this as detailed as DOMO's beastmodes can get

MarkSnodgrass

You can construct the format through some elaborate beast mode syntax, but it will still be viewed as text. If you search the community for beast mode formatting, you should see some examples. You could add a round function to eliminate pennies very easily, but the commas and $ signs require an elaborate beast mode.

GrantSmith

Here are a few posts on beast modes that may help you:

https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting

https://community-forums.domo.com/main/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number

https://community-forums.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting

gbrown

Thanks @GrantSmith !

This beastmode helped with removing decimals and still kept the color conditions active. What is the correct way to format this beastmode to be able to have commas in the value?

Thanks

GrantSmith

You can replace the FLOOR(SUM(`random_number`)) on line 11 in the example with the beast mode that will format the value with commas. You can refer to the Number Formatting link I sent earlier.

gbrown

Worked great! Thank y'all for the help!

GrantSmith

@gbrown Glad to hear it! If you could accept any answers that helped solved your problem so others can easily find the answers I'd appreciate it!

LMartin

Hello,
Can I use the HTML syntax to put colors in a pivot table with beastmode?
I'm trying to do a formula like:

CASE
WHEN AVG(SLA Calculation) >= 0.9 THEN concat('<div style="color: #ff0000">',AVG(SLA Calculation),'</div>')
ELSE concat('<div style="color: #00ff00">',AVG(SLA Calculation),'</div>')
END