(IMPORTANT UPDATE OF THIS POST: See How to calculate “Lead Time” or “Real Average Resolution Days” with eazyBI and JIRA (Part II))

The default calculated measure of eazyBIAverage Resolution Days” counts until the last Resolution filled ( not until the first value of the Resolution field), then if you set a new Resolution from “Resolved” to “Close” statuses, the value will be measured until “Close”. eazyBI counts the resolution time till the last resolution. This is a problem to measure some concepts like the “Lead Time”, or efficiency/performance in some projects.

How we can measure a perfect “Lead Time”?

The best way, I think, is the sum of the time spent in all statuses that counts for the measure that we want.

Then we can set a calculated measure in the dimension “Transition Status”.

Create a calculated member in the Transition status dimension with the formula like this (“Unresolved statuses“):

Aggregate({
  [Transition status].[Open],
  [Transition status].[Preparation],
  [Transition status].[Backlog],
  [Transition status].[In Progress]
})

See this example screenshots:

Captura de pantalla 2017-10-07 a las 21.23.57

Captura de pantalla 2017-10-07 a las 21.23.46

Then, you can create a new Calculated Measure in the “Measures” dimension showing the average time issues spent in those statuses:

CASE WHEN [Measures].[Issues resolved] > 0 THEN
([Measures].[Workdays in transition status], [Transition status].[Unresolved status]) 
 / [Measures].[Issues resolved]
END

This should calculate the average time till the first resolution.

See this example screenshots:

Captura de pantalla 2017-10-07 a las 21.24.21

Captura de pantalla 2017-10-07 a las 21.25.07

Then we can activate the Calculated Measure and see the expected result

Captura de pantalla 2017-10-07 a las 21.24.51

Many thanks for the support eazyBI team!

(IMPORTANT UPDATE OF THIS POST: See How to calculate “Lead Time” or “Real Average Resolution Days” with eazyBI and JIRA (Part II))

Advertisements
Posted by:.

4 replies on “How to calculate “Lead Time” or “Real Average Resolution Days” with eazyBI and JIRA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s