Date range (derived) filter not working on line chart

KharansuESSPL — Mon, 29 Nov 2021 09:50:33 GMT

Hi ,

I have a situation where I have created date range using a derived column called [Days Open] =

$(Today)-Date(Created date) as [Days Open] and then this is used to create the ranges as '0-30', '31-60', '61-365' and '>365'.

But while creating different lines for different date ranges and filtering them accordingly - like selecting only '31-60' or only '>365' doesn't give me single line - gives me all of them. What can be done?

Created date can be the dimension.

required calculations -

If(IsNull([Days Open]), null(),

If([Days Open]<31, '0-30',

If([Days Open]>=31 and [Days Open]<61, '31-60',

If([Days Open]>=61 and [Days Open]<365, '61-365',

If([Days Open]>365,'>365'))))) as [Range]

For individual lines, I have created different measures like -

Measure1 - Count({<[Range]={'31-60'}>}[Root cause])

Measure2 - Count({<[Range]={'61-365'}>}[Root cause])

Measure3 - Count({<[Range]={'>365'}>}[Root cause])

attached a sample excel

Thanks

Re: Date range (derived) filter not working on line chart

Sue_Macaluso — Mon, 29 Nov 2021 13:06:37 GMT

@KharansuESSPL Your post has been released.

topic Re: Date range (derived) filter not working on line chart in App Development

Date range (derived) filter not working on line chart

Re: Date range (derived) filter not working on line chart