color in total is not coming

[#1]

hello,

Please find attached qvw.

There is no color in total. color rules for total is same as other rows.

Can you help me in this,

Thanks

Amit

[stigchel · Accepted solution]

Change your color expression to (for the total there are more ScheduleHealth values then one, so you need an aggregation function)

if(Avg(ScheduleHealth/100)<.49,RGB(250,0,0),

if(Avg(ScheduleHealth/100)>.49 and Avg(ScheduleHealth/100)<=.85,RGB(250,150,0),

if(Avg(ScheduleHealth/100)>=.85,RGB(0,150,0),

if(Avg(ScheduleHealth/100)=.50,RGB(250,150,0),

null()))))

[#3]

Hi,

Thanks. cant I use label in background expression?

[stigchel]

It seems that the reference to the expression label takes the Expression total, which has no result for a non-aggregated expression. So not the average of rows, which you configured as total mode for this expression.

Also, I hope you realize that your expression shows no result for your dimension UID's where there are multiple ScheduleHealth values. Should this be a mistake use

Avg(ScheduleHealth/100)

Instead. Then the reference in background color to the expression label also works for the total

[#5]

Hi,

can I send u mail regarding this?

[stigchel]

I'm sorry, but I would like to keep the conversation in the community where others can contribute as well.