Our Jira workflow contains a number of transition statuses, and I’m using average days in transition status to generate a Cycle Time report. Now, I need to generate some totals from those values, e.g. I need to add transition statuses 1 + 2 (excluding statuses 3, 4, 5, etc.) to generate a new value. Any help on how to build a new calculated member appreciated.
Hi @nickY,
To get cycle time, you might want to use measures and dimensions designed for issue change history: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history.
For example, you might want to use dimension Transition Status with handpicked statuses 1 and 2 and measure “Days in transition status”.
You may use dimension “Transition Status” on pages and select multiple statuses of interest in a filter. Or you may define a new calculated member in Transition Status dimension and aggregate statuses that represents the cycle:
Aggregate({
[Transition Status].[status 1],
[Transition Status].[status 2],
})
Then you can use this calculated member in the report on pages, row, columns, and even in calculated measures.
Check out the solution on a similar use case here:
Best,
Zane / support@eazyBI.com