Count transitions to Executing per month

I am trying to sum and create a timeline for issues that was transitioned to status Executing per month. The data for transition month is correct, but it seems like with the measure I am using now it only calculates issues that are also still in status Executing:

  [Measures].[Transitions to status issues count],

Can you help me with including tickets that have since been closed into this calculation?

Hi @kiMMey,

Data on status transitions comes from issue change history. eazyBI offers a set of measures to analyze the history and few dimensions, including for transition statuses (Import issue change history - eazyBI for Jira).
Dimension “Status” represents only the latest issue status even used together with history measures. On the other hand, dimensions “Transition Status” and “Transitions” show all status changes.

Update the calculated measure like this:

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

Zane /

Hi @zane.baranovska

There is a way to use this measure but it does not calculate the transitions of the same ticket (if this step twice only counts me once)

@Marcelo_Ignacio_Cid1 there are several measures for analyzing issue status transitions (Import issue change history):

  • “Transitions to status issues count” - count of unique issues that had a specific transition.
  • “Transitions to status” - count of transitions.

To get cont of transitions, not issues, you might want to use measures “Transitions to status”.