Color Rules Help

LJ

Hi Everyone,

Can I ask if it is feasible to create a color rule in DOMO that highlights values in green if they meet or surpass the objective and red if they do not meet the target?

Thank you!

ColemenWilson

A similar question was asked yesterday:

https://community-forums.domo.com/main/discussion/62282/conditional-formatting-in-domo-card

You'd need the conditions to be in a beastmode so that the color rule can evaluate based on that one field. I think what you are trying to do is compare one column to the target column and then determine if it meets the criteria for a color rule based on that which is not possible.

MarkSnodgrass

Color rules are limited to comparing against specific values and can't compare against other fields unfortunately.

You can get around this by creating a beast mode that does the comparison and then build a concat statement that will color the text green or red using html div tags. The downside is that this value becomes a string and you would need to do any formatting (format to percent in your case) within the beast mode as well.

ColemenWilson

A similar question was asked yesterday:

https://community-forums.domo.com/main/discussion/62282/conditional-formatting-in-domo-card

You'd need the conditions to be in a beastmode so that the color rule can evaluate based on that one field. I think what you are trying to do is compare one column to the target column and then determine if it meets the criteria for a color rule based on that which is not possible.

MarkSnodgrass

Color rules are limited to comparing against specific values and can't compare against other fields unfortunately.

You can get around this by creating a beast mode that does the comparison and then build a concat statement that will color the text green or red using html div tags. The downside is that this value becomes a string and you would need to do any formatting (format to percent in your case) within the beast mode as well.

JasonKerr

https://community-forums.domo.com/main/discussion/comment/79840#Comment_79840

HTML is not supported in Pivot Tables, correct? How can this be accomplished in a Pivot Table?