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
