Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if
((Sum({<Product_Id={9},Timeframe=, Agg_Period=>}Volume))>$(vGreen),RGB(0,255,0),
if((Sum({<Product_Id={9},Timeframe=, Agg_Period=>}Volume))<$(vRed),RGB(255,0,0),
RGB(0,0,255)))
Hi Everyone,
I am using this expression to obtain bgcolor for my line chart. if my volume is greater than certain value its green. If Volume is less than Certain Value, It gives Red otherwise it gives blue.
But When I apply Time Frame Filter (which has been applied Null in above set expresssion), the green and Red Color dissappers and becomes blue.
Can any body tell me the solution for it ?
Thanx in Advance
try timeframe={'*'} but I'd like to see the object, can you post an example?