Color Coding or conditional formatting in DOMO?

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.

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

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.

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

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

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

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.

All comments

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.

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

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

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

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

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

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

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

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.

Worked great! Thank y'all for the help!