Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DialGauge intervals

Hello.

I want to use DialGauge to illustrate what degree of success with a certain metric. I want to illustrate the following: 

Great: 0-1 in green

Mediocre: 1-120 yellow 

Bad: 120-3120 red

 

However, because of the wide spread between the categories, the field in green is very small and almost impossible to see. The data has alot of smaller numbers and some larger. I was therefore wondering if it is possible with the visualization to decide that 1/3 of the gauge is 0-1, 1/3 is 1-120 etc, and lable the colors to illustrate the intervals? 

 

Thank you in advance.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    The color display is dynamic based on the values, but now you want it to be evenly split into three parts with different colors. And I'm afraid that's not possible with just the existing columns. Perhaps you could create another calculated column as follows and put that calculated column on the dial guage to instead the original value field. But this has the problem of not knowing what the actual values are...

    Column =
SWITCH (
    TRUE (),
    [Value] >= 0
        && [Value] < 1, 1,
    [Value] >= 1
        && [Value] < 120, 2,
    [Value] >= 120
        && [Value] < 3120, 3
)

    Best Regard