expression display as traffic light

[eva_maria]

Need to represent the expressions in the graphic that I have attached like traffic light gauge with 3 segments (red, yellow and green).

For example, first expresion (Q1_J) value will be:

Red: if Q1_J <avg(Q1_J) of all employees with same value in field “pto”

Yellow: if Q1_J =avg(Q1_J) of all employees with same value in field “pto”

Green: if Q1_J >avg(Q1_J) of all employees with same value in field “pto”

Regards

[sunny_talwar]

Like this?

=If(Q1_J < Avg(TOTAL <pto> [J_I1]), LightRed(),

If(Q1_J = Avg(TOTAL <pto> [J_I1]), Yellow(), LightGreen()))

[vvira1316 · Accepted solution]

expression for avg

Avg(TOTAL <pto> [J_I1])

Light Value setting

if ([J_I1] < Avg(TOTAL <pto> [J_I1]), -1,
if ([J_I1] = Avg(TOTAL <pto> [J_I1]), 0, 1))

gauge setting Min = -1, Max = 1

Red for -1, Yellow for 0 and green for 1

Uncheck autosegment

[eva_maria]

Hi! Vijay, that's perfect, exactly what I was looking for.

Thanks for your invaluable help and for your time

regards.

[eva_maria]

Hi Sunny.

I appreciate your answer because I didn't know the way that you proposed

Thaks for your help and your time

Regards