Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have trend line as in attached. Instead of the trend line I would need to show flash lights.
Below are the items which I used
Chart : Combo chart
Dimension1: DaysRange
Dimension2: =IF(Mixmatch(MaxProduct,'Soaps'),MaxProduct)
Expression: =today()-aggr(Date(max(DateInsert)),ProductID)
Trend line: Count(DISTINCT {$<DateType={'InsertDate'},DaysRange={'22-31 Days','32-60 Days','61-90 Days','91+ Days'},Flag={2}>} ProductID)
I need to show the light only if it crosses 15-21 days and if I click on 0-7 days/2-14 days/15-21 days bars I don't want to see the flash light. Please let me know is it possible?
Please see attached withouttrendline for 0-7 days/2-14 days/15-21 days bars
Thanks.
Please find attached.
Any solution?