Hi,
I have user stories defined with Story Point estimates as well as dev estimate.
As child items to those user stories I use
development task
testing task
What would be the best approach to create a report (or if not the best, any solution will do) which will allow me to compare dev estimate from User Story to the sum of effort spent only on development tasks?
All Stories and tasks have fix version assigned, so I will be interested only in those where version is assigned.
You can use Issue dimension Sub-task or Epic hierarchy Parent level on rows. This will show you all the Stories.
Then, on columns, select the Measures you are interested in - the estimate and effort (is this the Hours spent?). Further you can create following calculated member that will sum all Development task Hours spent from the current story Children set with following formula.
CASE WHEN [Issue].CurrentHierarchyMember.Level.Name MATCHES
"Parent|Sub-task"
THEN
Sum(Filter(
ChildrenSet([Issue].CurrentHierarchyMember),
[Measures].[Issue type] = "Data task"
), ([Measures].[Hours spent], [Issue Type].DefaultMember))
END
Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com