3 Replies Latest reply: Aug 19, 2016 12:32 PM by John Blomqvist RSS

    Why doesn't this simple line background colour expression work?

    John Blomqvist

      Hi,

       

      I have the following chart:

       

       

      Dimension: MonthYear

      Expression: Count(Distinct OrderID)

       

      In background colour for the expression is If(Count(DISTINCT OrderID) > $(vAVGOrders), LightBlue(), LightGreen())

       

      My variable vAVGOrders expression is: Avg(Aggr(Count(DISTINCT OrderID), MonthYear))


      Why doesn't my chart above change to lightblue colour when the line is going over Avg # Orders? What do I need to change please?