2 Replies Latest reply: Aug 10, 2012 8:23 AM by Nick Gan RSS

    how to fixed color by data

    Nick Gan

      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.