Cumulative days in Transition Status

Questions & Answers
1

Looking for some guidance here.

I am looking at a list of completed Jira issues (Current Status == Closed) and the Original Estimated Hours and Hours Spent on each. Looking to also include the number of workdays each issue was in the ‘In Progress’ transition status. Since quite a few of the ~300 tickets have been moved back to ‘In Progress’ more than one time, this creates an additional row for each time the issue was ‘In Progress’ (e.g. an issue which has been ‘in progress’ 3 separate times results in three rows in the resulting table.

Looking for a solution to derive the sum of Workdays in Transition Status for each ticket (one row).

Thanks in advance.

-Chris

2

Chris,

Perhaps, your report is designed in a specific way that generates the multiplication of rows.
The simplest solution for the sum of workdays in transition status is the following formula:

([Measures].[Workdays in transition status],
 [Transition Status].[In Progress])

It should not multiply the records by the number of transitions to the status.

image
image.png2070×658 65.8 KB

Kindly,
Janis, eazyBI support

3

Use the distinct issue measure

https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history