Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you upload a small sample?
When you making the avg you have to use agg function.
if(aggr(sum(Value),Dim)/aggr(Count(Value),Dim)<10,red(),Green())
This 51 should be yellow but it is not
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?