Transition from one custom field to another

Questions & Answers
1

Hey everyone,

In our Jira project, we have a custom field called IT Teams, and respectively teams a,b,c,d,e …
I’m trying to get the number of tickets that are transferred from the custom field a to d.

I created a new calculated member using :

([Measures].[Transitions from issues count],
[Transition Field].[It team],
[IT Team].[a]
)
(
[Measures].[Transitions to issues count],
[Transition Field].[It team],
[IT Team].[d]
)

bu the data is not accurate. when I drill through the issue- I see tickets that were moved from a to c, or a to b.
Is there something that I’m missing?

Thank you in advance for your reply,
Dorina

2

Hi @Dorina_Ababii,

You were going in the right direction as much as MDX allows.
The expression to calculate the transitions from A to D indeed looks at each end of the transition separately.

The expression that looks for the transitions from A, then for transitions to D and compares that they are equal works best with granular Time dimension members.

The expression might be as follows.

Sum(
 Filter(
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
  ([Measures].[Transitions from],
   [Transition Field].[IT team],
   [IT Team].[a])>0
 AND
  ([Measures].[Transitions to],
   [Transition Field].[IT team],
   [IT Team].[d])>0
 AND
 ( ([Measures].[Transitions from],
    [Transition Field].[IT team],
    [IT Team].[a])
=
   ([Measures].[Transitions to],
    [Transition Field].[IT team],
    [IT Team].[d]) )
   ),
1
)

However, if your report covers periods where there might be multiple transitions there and back, like A-B-C-D or B-D-A-C or A-C-A-D within the same displayed time dimension member, then you might need to consider direct transitions via JavaScript calculated custom field dimension.

Please get in touch with us over e-mail to see the possible options for you.

Regards,
Oskars / support@eazyBI.com

3

Unfortunately, most of my cases are like this: A-B-C-D or B-D-A-C or A-C-A-D .
Can you guys help me with the JavaScript calculated custom field dimension?

Thank you in advance,

4

Hey Guys,
There is something you can help me with in this case?

Thanks in advance
Dorina