Date range (derived) filter not working on line chart
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]>=31and[Days Open]<61,'31-60',
If([Days Open]>=61and[Days Open]<365,'61-365',
If([Days Open]>365,'>365'))))) as[Range]
For individual lines, I have created different measures like -