Reverse the inclusivity of 0 in Multi-Value Column for Value changes

Samuel. · 2023-10-19T16:20:41+00:00

There was an error rendering this rich post.

Hi all,

I might be being daft here, so I am raising a question before raising an idea in case anyone knows of a workaround to my problem.

I'm looking to use a value change graphic to show the changes in the number of risks on projects. As a result of this, an increase is "bad", but a decrease or consistent value (0) is "Good".

This means anything above 0 should be Red, and anything below 0, notably including 0, should be Green. Colour rules don't seem to be available on Multi-Value Column cards, so I am limited to using the colour options built into the card. As a result, I have no way to make my 0 values "Good/Green" as they inherit the positive value colours.

What I want in interval notation:

Good/Green: (-∞,0]
Bad/Red: (0,∞)

What Domo offers in interval notation:

Good/Green: (-∞,0)
Bad/Red: [0,∞)

If there were a way to colour 0 specifically, that would also work, but I can't find that option either.

Best,

Sam

Find more posts tagged with

Visualization

Cards

Charting

Color

Card Builder

Accepted answers

GrantSmith

It's currently not supported by default. I'd recommend adding an idea to the idea exchange to add an option for 0 specific colorization. I'm sure others are wanting to do this as well.

You could possibly try and "shudder" your values by adding a trivial amount (0.001 for example) so that you don't have it being exactly 0 but slightly off of 0.

All comments

MichelleH

@Samuel. Can you show a screenshot of how you set your color rules?

MarkSnodgrass

Have you tried swapping the values that are in the gauge value and comparison value? I think the default chart properties might actually work for you if you switch which values you have in the gauge and comparison values.

Samuel.

Hey @MichelleH, they are the default Multi-value Column card settings except, under the "Change Value Options", I have ticked the "Reverse Color Direction" option.

@MarkSnodgrass Unfortunately, I've also tested that, and it still includes the 0 as a negative value.

GrantSmith

It's currently not supported by default. I'd recommend adding an idea to the idea exchange to add an option for 0 specific colorization. I'm sure others are wanting to do this as well.

You could possibly try and "shudder" your values by adding a trivial amount (0.001 for example) so that you don't have it being exactly 0 but slightly off of 0.