Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm doin this in the dimension.
if(aggr(days,sales) >1, '>1' ,
if(aggr(days,sales) >2, '>2'
) .. and many many more if() for other days buckets , also consist of negative days.
... basically, we will have the days bucket in the chart.
Then, in experession, i do a count(), so we will have the counting of how many sales for more than 1 day, 2 days...etc
and i stacked it. now, the problem is, how can i set a color for >1 to be always green?
i did this... some bucket works, and some doesnt... any helps please....
if(aggr(days,sales) >1, green(),
if(aggr(days,sales) >2, red()
)
Thansk.
Hi,
what is the kind of chart/table that are you working on?
In general, there is Background color property of dimension/expression, where color can be set.
regards
yup, i'm putting it directly in background color, but for some reason, certain level of if() wont display the color properly... and i don't know why .... maybe aggr() is not good ?