Average time between selected Sprints

Hi everybody!
I’m currently using this
Descendants([Time].CurrentHierarchyMember, [Time].[Day]),
[Measures].[Time within Sprint] > 0 ),
[Measures].[Hours spent with sub-tasks] * 60)
To retrive the number of hours in a Sprint.

But I wanted to go further are get the average hours of e several Sprints selected in Page.

Any idea how to do this? Variations on the metric above don’t seem to work.


Hi @Miguel_Silva!

The Time within Sprint returns if the time is within one particular sprint. If you wish to select multiple sprints you could use similar approach as in this example report: https://eazybi.com/accounts/1000/cubes/Issues/reports/201445-active-multiple-sprints-story-points-burn-down.

With Sprint in Pages and Time within Multiple sprints you would get the x-axis to display days from all selected sprints. Then you can add the Hours spent with sub-tasks measure and add the standard calculation to get the AVG of Hours spent: https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure.

Lauma / support@eazybi.com