How to split development and testing tasks

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.

Thanks and appreciate your help
Marcin

Hi Marcin,

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