Transition from one custom field to another

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,

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.

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

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.

Oskars /

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,

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

Thanks in advance