HTML conditional color format as percentage of goal

One thing you could do would be to create a BeastMode to check the current value against the goal. 

Something like this:

CASE WHEN `Current` < `Goal` THEN 1
           WHEN `Current` = `Goal` THEN 2
           WHEN `Current` > `Goal` THEN 3
END

Then you could use the new BeastMode field in your color options like so:

From there you could repeat the excercise for trending and assign new colors. (Make sure to uncheck the 'Apply format to table row' if you don't want the entire row to be highlighted the specified color)

Hope this helps. Let me know if you have any other questions.

Sincerely,

ValiantSpur

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

That's a nice idea.  Make sure to add it to the Ideas Exchange.

More generally, colors changing once they meet a condition is something Domo is working on, but could be better.  Conditional formatting is part of new table cards, so you could transition card types if you want to take advantage of that.

There may be another approach you'd be interested in as well.  We use simple guage cards for a similar purpose, sales trend to sales quota and current sales to sales quota.  We set up those figures as ratios, like 65% or 114% to goal, and use the guage range color options to indicate progress to goal (like, green over 100%). Then in the card summary number we create a multiple number beast mode to show all values, not just the ratio, for further detail.  This type of card is one of the first cards on every sales page since it's so simple and effective.