I am trying to figure out how to create a similar sprint committed/completed velocity chart in eazy bi that is in the out of box jira report. I’d like to create this with original estimates since were using this approach rather than story points.
I understand you would like to calculate Original estimated hours for issues committed to a Sprint and for issues completed in a Sprint. To create such report, you may define new calculated measures to get similar measures as for Story Points.
For example, measure for committed original estimated hours could be built using existing measures Sprint issues committed and Original estimated hours.
A formula for “Sprint original estimated hours committed” may look like this.
Sum( Filter( -- iterate through issues commited to a Sprint Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]), [Measures].[Sprint issues committed] > 0 ), -- original estimate for each commited issue ([Measures].[Original estimated hours], [Sprint].DefaultMember) )
You may define a similar calculated measure for “Sprint original estimated hours completed” based on measures Sprint issues completed and Original estimated hours.
Zane / support@eazyBI.com
This doesn’t appear to work when I have ‘Sprint’ in my rows dimension and ‘Measures’ in my columns dimension.
I encountered the same problem: