on eazybi for jira, I want to show sum of all remaining work of issues that added to sprint after sprint start.
I put sprint in pages, assignee in rows and Sprint remaining estimated hours added in Columns but this field is empty
what should I do? please help
Measure “Sprint remaining estimated hours added” returns the total of remaining estimated hours for issues which were in a selected sprint.
To sum remaining estimated hours only for issues which were added to a sprint after sprint started, you may define a new calculated measure in Measures. For calculation use similar approach as for measure “Sprint Story Points added”.
A formula for Sprint remaining estimated hours added after sprint start may look like this:
( [Measures].[Remaining estimated hours added], [Transition Field].[Sprint status], [Sprint Status].[Active], -- an issue was added or created in an active sprint [Issue Sprint Status Change].[(none) => Active] )
Make sure that issue change history is imported and you have selected some sprint in the report.
Zane / support@eazyBI.com