Conditional colouring

ZeinHaddad · June 2018

Is there a way that I can conditionally colour one line/bar in relation to another dynamically-changing value in the chart? I.e: if line/bar for actuals are above target then the colour changes from red to green? (Note: the goal-line in the chart is not helpful because the target values dynamically change).

Many thanks!

Valiant · June 2018

The only way to do that currently would be to have a column that evaluates whether the goal is met and flag something like Yes or No as your data updates. It would need to process on the ETL side the card in order to work.

I like the idea you have and there is actually another already out there on the Ideas Exchange here:

https://dojo.domo.com/t5/Ideas-Exchange/Conditional-formatting-relative-to-other-metrics/idi-p/30703

Be sure to like it to increase visibility.

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.

Chips · June 2018

NOT A FULLY BAKED SOLUTION BUT...

I once saw something similar solved in Excel by creating two series of data.

1. Your Green, continuous

2. Your Red, conditionally shown only when value was below the threshold

If the goal is > 10

Green - 8, 7, 11, 13, 9

Red - 8, 7, null, null, 9

The red would "show up" and "cover up" green only when it was below 9.9999999, so to the reader it appears as one continuous line that is changing colors as it goes.

I haven't attempted the same in Domo, but perhaps this idea could at least nudge you in the right direction.

Good luck!

Chips

Conditional colouring

Comments

Categories