I am trying to create a new calculated measure which should return me the number of tickets moved to particular status from another status

Questions & Answers
,
1

I am trying to create a new calculated measure which should return me the number of tickets moved to particular status from another status. I have created a formula but its not working and returning me a blank field.

Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
(
[Measures].[Transition from status] = “Dev Complete” OR
[Measures].[Transition from status] = “In development” OR
[Measures].[Transition from status] = “Code Review” OR
[Measures].[Transition from status] = “Ready to verify” OR
[Measures].[Transition from status] = “In QA (UAT)” OR
[Measures].[Transition from status] = “Complete (Dev/QA)”
)
AND
[Measures].[Transition to status] = “In QA (Stage)”
),
[Measures].[Transitions to status]
)

Is there anything i am missing here?

2

Hi Sanjay!

You might want to try using an aggregate in the Transition dimension and then use that in you calculated measure with [Transition from status]

In [Transition] Dimension the new member would look something like
name: Transition_status

aggregate({
[Transition].[“Dev Complete” => “In QA (Stage)”],
[Transition].[“In development” => “In QA (Stage)”],
[Transition].[“Code Review” => “In QA (Stage)”],
[Transition].[“Ready to verify” => “In QA (Stage)”],
[Transition].[“In QA (UAT)” => “In QA (Stage)”],
[Transition].[“Complete (Dev/QA)” => “In QA (Stage)”],
})

After that in measures your query would look something like
([Measures].[Transition from status], [Transition].[Transition_status])

I hope this helps!
Good luck :slight_smile:

3

Hi @Marilou
Still its returning the blank record when i am using it in my reports.

4

Try putting Dimension Status in Colums, in Rows Issues and as Measure [Measure].[Transition from Status]
Hide empty and remove the transitions you don’t want.

5

@_P3
This way is including some extra records as well for example : in development status showing the records for those cases as well when dev himself moved it but i want to consider only those in development records that were moved by QA. Thus i want to consider only those in development records that were moved to “In development” status from “QA Stage”

6

If you create

aggregate({
[Transition].[“Dev Complete” => “In QA (Stage)”],
[Transition].[“In development” => “In QA (Stage)”],
[Transition].[“Code Review” => “In QA (Stage)”],
[Transition].[“Ready to verify” => “In QA (Stage)”],
[Transition].[“In QA (UAT)” => “In QA (Stage)”],
[Transition].[“Complete (Dev/QA)” => “In QA (Stage)”],
})

in Transition (as Marilou said) and you use this created field, you can select those transitions you want by adding or removing them).

7

Hi,

The suggested approach for the solution is on the right track.

The actual formula might depend on how your report is designed. So, please contact eazyBI support for further guidance. Do not forget to send the report definition and a screenshot of the report you have.

Kindly,
Janis, eazyBI support