How to show Original Estimate hours for closed sprint?

Hi!

Could someone suggest how to solve the problem that Orignal Estimate field is empty in Closed Sprint?

I have already tried some tips how to solve it, but it doesn’t work
https://eazybi.com/accounts/1000/cubes/Issues/reports/395696-sprint-time-tracking-remaining-estimate-balance

I will be grateful if someone could suggest any solutions.

Best!

@EazyBILearner @easybi Maybe you can help with this issue?

Hi,

The Original estimated hours is a measure showing the “current status.” Once you use this measure with the Sprint dimension, the values show for those issues/sprints where the issue is currently. So, once the issue is moved from a closed sprint, the Original estimate does not show up.

A workaround is to use a custom measure like this:

NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
   0
))

This measure checks if the issue was in the sprint at closing and shows that estimate, regardless of to which sprint issue belongs currently.

Kindly,
Janis, eazyBI support

Hi @janis.plume!

Thanks for your help!

Everything is working fine! But unfortunately I missed that I need to show the Original Estimate Hours value for closed, active and future sprints in one line, I already tried to change your custom measure but it was not successful.

Hi @eazyBI-Staff

I have resolved the issue from the previous comment by changing the provided formula to

NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
  Original estimated hours
))

But, Now I noticed that it shows incorrect Total value in different reports,

Do you have any suggestions on how to solve it?

@Yevhenii_Pasichko
Try using the annotation sum in your formula:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Specialcommentswithannotations

Something like:

-- annotations.total=sum
NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
  [Measures].[Original estimated hours]
))

That should force the sum function at the Total level of the report.

Martins / eazyBI