Workload pie chart for spent time in a story per sprint per assignee

[yafit]

I am using a dashboard with a workload pie chart to understand the total time spent per each assignee in a sprint, in order to understand the workload per each team member. 

The issue we are seeing is that - for stories that are dragged in more then 1 sprint - the total time is presented in all sprints - which makes the statistics incorrect...

for example : 

if i have a story that took 5 weeks which was done dusing 3 sprints 

sprint 1 - 2 weeks - we have 1 sub task = 2 weeks 

sprint 2 - 2 weeks - 1 sub task = 2 weeks 

sprint 3 - 1 week - 1 subtask = 1 week 

i will see in the workload pie for each one of the sprints - the same number of time spent = 5 weeks and not what was done in each sprint ...

How can we solve that ?  

[Walter Buggenhout · Accepted solution]

Hi @yafit and welcome to the Community!

I would be very interested to see how you are displaying this information in a pie chart. You mention at least 2 dimensions: sprint and assignee. As a pie chart can only represent 1 dimension, having a visual of what you are doing (maybe you have a pie chart per sprint?) might help me get a better understanding.

Nevertheless, time is not spent against a sprint. It is spent against an issue, and Jira has no way of knowing what time was spent against which sprint if an issue is being carried over. Well, unless you bring the time dimension (the date when hours were logged) into the report, but that is something out of the box dashboard gadgets are not capable of.

You would need a more solid BI reporting solution to get that information reported on correctly. You might want to look at BI Connector apps from the marketplace to easily get your Jira data into a reporting tool you may already have or look at EazyBI to bring reporting capabilities right into your Jira instance.

Hope this helps!

[yafit]

Thanks for the reply. 

I am using a pie chart per sprint

It is weird that there is not an OOB solution for dragged  stories - since it is a situation that happens a lot ...... it seems that we will need to split the stories in to several stories . 

Is there any way of assigning sub tasks to a sprint ? that will solve it ...meaning a story will have sub tasks and each sub task will be assigned to a different sprint .....