Count transitions to Executing per month

Hi,
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],
  [Status].[Executing]
)

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]
)

Best,
Zane / support@eazyBI.com