Hi,
In this case, I would first create new calculated member in “Transition Status” dimension (which will be used for requirement a) and one also in “Status” dimension (which will be used for requirement c). Both code examples below.
For “Transition Status” dimension:
Aggregate({
[Transition Status].[Analyze],
[Transition Status].[Clarify]
})
and for “Status” dimension.
Aggregate({
[Status].[Coded],
[Status].[Verify],
[Status].[Closed]
})
For a and b requirement, then I would use the measure “Days in transition status” in columns and “Issue” dimension (at issue level) in rows. And finally drag “Transition Status” dimension to pages, where I would enable the new calculated member
In a similar way, I can filter the same report for requirement b
For the last requirement, I would use “Issues created” in columns, “Reporter” dimension (at the user level) in rows and then select new “Status” dimension calculated member in rows.
See both described reports attached as images below.
Martins / eazyBI support
