Trend line disable?

[#1]

Hi,

I have combo chart with trend line. Is there any way that I can disable the line up to 15-21 days. i,e for 0-7 days, 8-14 days, 15-21 days.

Please see attached. can anyone suggest me. I have below dimensions and expressions.

Dimension 1 : DaysRange

Dimension 2: =IF(Mixmatch(MaxOrder,'Crestt'),MaxOrder)

Expression 1: Count(DISTINCT {$<DateType={'LoggedDate'},Department={'0'},Flag={2}>} ID)

(Trend line)Expression 2: Count(DISTINCT {$<DateType={'LoggedDate'},DaysRange={'22-31 Days','32-60 Days','61-90 Days','91+ Days'},Flag={2}>} ID)

[chiru_thota · Accepted solution]

Have you tried Chart properties --> Presentation --> Suppress Zero-values ?

[SunilChauhan]

Try this

Count(DISTINCT {$<DateType={'LoggedDate'},DaysRange-={'15-21 Days'},Flag={2}>} ID)

[#4]

Perfect that's working.