We have a custom field(Stages) of type cascading which has Parent Value as “WT” and Level 1 values are,
1. First value/test
2. Second value/2nd test
3. Third value
4. Fourth value
We need a report to show number of days(Ageing) each issue has spent in each Level 1 value’s. It is easy when we try to look for a report with issue’s “Status”, but with the custom field value it’s bit tricky. I was able to get partial report with below custom measure(But the days spent in current value till now doesn’t come in the report).
DateDiffDays(TimestampToDate(([Measures].[Transition to first timestamp],
[Transition Field].[Stages])),TimestampToDate(([Measures].[Transition from last timestamp],
We’ve setup advanced setting for custom field to fetch issue’s history.
Cascading field's advanced setting
Appreciate your help on this. Thanks!