Planned vs actual effort spent on the activities during sprint

Questions & Answers
1

We have a big team and many people work in specific areas, so it is difficult to say if a bug is indeed in one area one developer can directly work on the same, so many times 2 or 3 persons work on a single JIRA ticket. What we are looking forward to is the efforts planned at the start of the sprint (based on the remaining estimate on day one when the sprint started) and the time spent by the individual on the activity over the sprint. We would also like to drill down to the details like which tasks took maximum effort (compared to estimated / remaining time) and the status of the tasks.

2

Hello @Chinmay,

Thanks for posting your question!

There are a couple of reports in our Demo account that could serve as a base for your report:

  1. Time Tracking Burndown in Selected Sprint - Issues - Jira Demo - eazyBI
    Time tracking burndown in Selected Sprint shows the current trend of spent hours, optimal guideline for committed hours as well as remaining estimated hours history per selected sprint.

You can then use “Drill through worklog” option to see more info on how many hours have been logged by each User on an Issue or “Drill through Issue” to see how many hours were spent on a specific Issue.

image.png
image.png2354Ă—964 142 KB

image.png
image.png2634Ă—498 48.9 KB

  1. Sprint report (Time Tracking) - Issues - Jira Demo - eazyBI

You can modify this report by adding “Logged by” and “Issues” dimensions in Rows.

image.png
image.png2876Ă—1366 473 KB

  1. An additional report that might be interesting for you, if you are interested in Sprint Time Tracking (Remaining Estimate) balance: Sprint Time Tracking (Remaining Estimate) balance - Issues - Jira Demo - eazyBI

image.png
image.png2752Ă—1472 355 KB

Here again, you can Drill through worklogs or Drill accross “Logged by” to see more detailed information.

I hope this helps, but please let us know if you have any further questions.

Best,
Marita // support@eazybi.com

3

Hello Marita,

First of all, thank you very much for the response
I think you didn’t get the problem fully which I’m looking forward to.
“Sprint Remaining Estimate committed” works well on the entire team, but if I have to look at the data at individual levels I don’t see any value.
I understand this is because time logged by and the current measures are not in the same dimension
I’m looking forward to the help on the same.
We are trying to look forward to individuals and teams under a lead and how well they are performing

image
image1379Ă—778 47.3 KB

4

Hello @Chinmay,

Thanks for the follow-up. Can you add the Assignee dimension in Rows & then click on one of the Sprints in your report and choose “Drill across” → Assignee → User.

Note, if you want to use the measure Hours spent with the Assignee dimension, you need to create a new calculated measure:

(
   [Measures].[Hours spent],
   [Logged by].[User].GetMemberByKey(
     [Assignee].CurrentMember.Key
   )
)

This is the report I am getting:

image
image2330Ă—966 200 KB

Is this what you were looking for?

Thanks,
Marita // support@eazybi.com

1 Like