This content has been marked as final. Show 3 replies
I have the following chart:
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?