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!

Posted by:e6967712

One thought 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s