I am trying to create a table that shows me, per quarter, how many issues got transitioned to Priority 'High'. I am able to do that using
CASE WHEN(([Measures].[Transitions to], [Transition Field].[Priority])-
([Measures].[Transitions from], [Transition Field].[Priority])) > 0
THEN
Aggregate(([Measures].[Transitions to], [Transition Field].[Priority]))
END
although I'm not 100% sure that's exactly what I'm looking for. Here are the problems I'm running into:
I created several different measures that I'm using together but at this point I don't think any of them are correct. Is anyone able to help?
Hi Nicole,
The solution for your case is to use the Issues History measure. It works with the Priority and Time dimension and can show the amount of the Issues with the selected priority at the end of the period chosen.
You can create a report like in the attached screenshot (I used months in the Time dimension):
However, the Issues history measure cannot distinguish if the issue has the Priority from the birth, or have the transition later. A new custom calculation should fix that:
nonzero(count(
Filter (Descendants([Issue].CurrentMember,[Issue].[Issue]),
IsEmpty(([Measures].[Issues history],
[Time].[Day].DateMember(DateParse([Issue].CurrenthierarchyMember.get('Created at'))),
[Priority].[High]))
and
([Measures].[Issues history],
[Priority].[High])>0
)))
This measure is designed to work also without the use of Priority dimension in the report, so, please note to check if the correct Priority name is used in the code.
Kindly,
Janis, eazyBI support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.