I have a report which includes the measurement “Issues not closed”. This works fine and as expected.
However I would now like to add a measurement which shows the number of tickets in specific states for the current week. So for example show all tickets which in week 48 where in one of the status A, B or C.
Could give me a hint on how to do this?
You can use tuples as explained here: Calculated measures
Example of Formula
thanks for the response.
This however seems to be adding the issues in these status on top each other, week by week.
What I would need is having a number showing how many issues are in specific status in each week.
Something like for open issues as in this measure but instead for specific status:
CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
- [Measures].[Issues closed])
+ [Measures].[Issues created]
- [Measures].[Issues closed]
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero([Measures].[Issues due])
-- optimized formula for drill through Issue
The solution is to use the Issues history measure with the Transition status dimension.
Please, check this example report in the Demo account:
Janis, eazyBI support
I got it working with Issue History.