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



      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?