In chart text colour conditioning

[aaronnayan]

Hi Guys

I have an expression its not coming out right

Metrics

0-50= RED

51-70= YELLOW

70-90=GREEN

90+= BLUE

This is whats coming out currently

Can anyone help with this

If you could write the correct expression it will help significantly

[Frank_Hartmann]

can you upload a small sample?

[dberkesacn]

When you making the avg you have to use agg function.

if(aggr(sum(Value),Dim)/aggr(Count(Value),Dim)<10,red(),Green())

[aaronnayan]

This 51 should be yellow but it is not

[Anil_Babu_Samineni]

Can you try this?

If(Avg(Date) >= 0 and Avg(Date) <= 50, Red(), If(Avg(Date) >= 51 and Avg(Date) <= 70, Yellow(), If(Avg(Date) >= 71 and Avg(Date) <= 90, Green(), Blue())))

But, I doubt how Avg(Date) given the values to you?