Calculated measure for a subset of transition statuses

Questions & Answers
2

Hi @nickY,

To get cycle time, you might want to use measures and dimensions designed for issue change history: 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