How to filter the issues that passed a certain status in a given month

Questions & Answers
1

I’m trying to build a line chart that shows how many issues transitioned into Status B every month and the average time those issues spent in Status A.

The number of issues, I’ve got it. I created a calculated member named Nb Status B that is defined as this:

[Measures].[Transitions to status issues count],
[Transition].[Status B]

The average number of days is where I’m stuck.

I created a calculated member defined as such

Sum(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),

DateInPeriod(
([Measures].[Transition to status last date],[Transition Status].[Status B]),
[Time].CurrentHierarchyMember)

AND [Measures].[Nb Status B] > 0),

([Measures].[Days in transition status],[Transition status].[Status A],

[Issue type].DefaultMember,
[Time].CurrentHierarchy.DefaultMember)

)

/ [Measures].[Nb Status B]

The value I’m getting is “yyyy-mm-dd hh:mm:ss” isntead of a nukmber of days.

While trying to debug, I created a calculated measure as

[Measures].[Transition to status last date],[Transition Status].[Status B]

and it does give me the correct transition date, so I’m guessing it’s the DateinPeriod that’s causing issues, maybe it’s a syntax issue or a value format issue?

It’s copied from another calculated measure (not by me) that uses [Issue].CurrentMember.get(“Closed at”) but the “Closed at” date isn’t what I need to filter on so I tried to modify it.

2

Hi @Merchillio,
From the value you are getting it looks that you have left the default measure formatting that incorrectly identifies the value returned.
Please try changing the measure formatting to decimal number: Calculated measures and members - eazyBI for Jira

Also, check if you have added parentheses to your first measure and are you using the “Transition Status” or “Transition” dimension?:

([Measures].[Transitions to status issues count],
[Transition].[Status B])

Best,
Gerda // support@eazyBI.com

1 Like