gauges chart concept

[didierodayo]

Hello,

I haven't played with gauges in the past so I need some help with the sample tables below.

I would like to create a gauge chart with the conditions:

Green >>> so 0 up to < LimitA   (this level may change)

Yellow>>> LimitA up to less than limitB  (this level may change)

Red >>>> above LimitB

Needle >>   if the AVG(UsageRate) is < LimitA then it is in green

>=LimitA and Less than LimitB then it is in Yellow

>=LimitB then it is in Red

When no selection is made it is be the overall average that is considered otherwise. Let me know if I need to clarify any point.

Thanks for your assistance

T1:
LOAD * INLINE [
CustomerID, UsageRate%, Category
123, 35, uyt
124, 46, uyt
125, 73, uyt
126, 89, uyt
127, 21, uyt
];

T2:

LOAD * INLINE [

Category, limitA%, LimitB%
uyt, 50, 60
];

[rahulpawarb]

Hello didierodayo,

Hope you are doing well!

Please refer below steps:

Open properties page of Gauge chart and locate Presentation tab. Set the following configuration under Gauge Settings section:

- Min and Max values will be 0 and .9 respectively.

- From the Segment Setup section, add one segment by clicking on the Add… button (make it three segments)

- Deselect the Autowidth Segments checkbox at the bottom of the window (When selected, the Autowidth Segments function automatically sizes the segments based on the Min and Max values of the gauge. We want to avoid this as we want to set the values ourselves.)

- We'll now have three segments and will set up each of the three segments is in the following manner:

• Segment 1:

°° Lower Bound: 0.0

°° Color set to Two Colors Gradient with the Base Color option set to Green (R:0; G:255; B:0) and the Second Color option set to Yellow (R:255; G:255; B:0)

°° Color Gradient Style option should be set to Vertical

• Segment 2:

°° Lower Bound: 0.3

°° Color set to Two Colors Gradient with the Base Color option set to Yellow (R:255; G:255; B:0) and the Second Color option set to Red (R:255; G:0; B:0)

°° Color Gradient Style option will be set to Vertical

• Segment 3:

°° Lower Bound: 0.6

°° Color set to Two Colors Gradient with the Base Color option set to Red (R:255; G:0; B:0) and the Second Color option set to Red (R:255; G:0; B:0)

°° Color Gradient Style option will be set to Vertical

Regards!

Rahul

[didierodayo · Accepted solution]

Here is the finish product based on the requirement above Cheers. Thanks Rahul