Hi, I would like to publish a report of all issues “In progress”, with original estimate, hours spent and remaining hours. I am able to get original estimate and hours spent as “issue properties”, but not remaining estimate (which is different from remaining hours calculated by subtracting hours spent from original estimate).
Is there a way to do this?
Hi @gsurekha2001,
You are right. eazyBI doesn’t import the “Remaining estimate” value as an issue property. Nevertheless, you can achieve the unfiltered value for each issue by defining a new calculated measure with the formula below:
DefaultContext((
[Issue].CurrentHierarchyMember,
[Measures].[Remaining estimated hours]
))
Please look at our documentation page for more information on defining calculated measures - Calculated measures and members.
Best,
Roberts // support@eazybi.com
1 Like