How can I measure estimation VS time spent by individual?

ganna_kyselevych April 22, 2024

Hi, community.


I have the following request:

1. Need to measure time spent VS time estimated on sprint basis by individual.

2. The complexity #1 is that sometimes tasks migrate from one sprint to another, that is why the original estimate not always works for my needs.

3. The complexity #2 is that sometimes tasks are being added to the sprint after start (

4. I use Capacity tracker https://pdffiller.atlassian.net/jira/marketplace/discover/app/capacity-tracker-plugin for sprint estimation and Team Reports for time logging. 

Have troubles only with correct and not manual estimation for the sprint. It is important because our team has KPI Estimation accuracy.

3 answers

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 22, 2024

Hi @ganna_kyselevych 

I am curious about your question...

You ask about "VS time", which I am guessing means "value stream time" or some interpretation of lead time or cycle time.

And you note using sprints, and so there is probably a team using Scrum.  What problem are you trying to solve by measuring that number for individuals rather than for the team's work as a whole?

Kind regards,
Bill

ganna_kyselevych April 24, 2024

This time could be called as "Estimation accuracy" as well.


It means that every team member estimates their tasks for the sprint, then logs real time and the best option when estimation and logged time match or almost match.


What we solve by calculating it by individual: keep every team member accountable for their time, track under- or overutilization of resources. It is one of our individual KPIs. 
We do calculate team KPIs as well, but we do need individuals'. Let's say, the specific of our team.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 24, 2024

Wouldn't the leader of the people on the team and the entire team already know this  information from paying attention and asking questions during 1-1 conversations and the daily scrum (stand-up), respectively? 

For example, a forecast is provided, and after repeated daily scrums no concerns are raised and progress seems stalled.  The team and leader should engage to learn why and what they can do to help, perhaps swarming on the challenge to resolve it.

Like Walter Buggenhout likes this
0 votes
Olha Yevdokymova_SaaSJet
Atlassian Partner
August 12, 2024

Hi, @ganna_kyselevych 
While the tools you're currently using offer some helpful features,
handling task migration and additions within sprints for your KPI estimation accuracy can indeed be tricky.

Jira's native reporting and Capacity Tracker might fall short when it comes to tracking time spent versus estimated time specifically within the context of a sprint, particularly when tasks move between sprints or are added after the sprint has started.

However, the Time & Cost Tracker for Jira add-on offers features that can streamline this process and provide the accurate sprint-based time tracking you need. Here's how it can help:

  1. Accurate Time Tracking, Even With Task Migration: Time & Cost Tracker seamlessly integrates with Jira's time tracking, so any time logged on a task is captured, even if that task moves to a different sprint. This means you get a true picture of the time spent on tasks within the sprint they were actually worked on, not just their original sprint.

  2. Handles Mid-Sprint Task Additions: Any tasks added to a sprint after it starts are also included in the Time & Cost Tracker reports for that sprint, ensuring your time tracking remains accurate and reflects the actual work done during that period.

  3. Sprint-Specific Reports: The add-on allows you to generate Time Reports filtered by sprint, giving you a clear breakdown of time spent versus estimated time. 

How to set it up:

  1. Install the Time & Cost Tracker add-on.
  2. Ensure your team is logging time using Jira's native time tracking functionality.
  3. Generate Time Reports, filtering by the specific sprint you want to analyze.
  4. Review the 'Planned Time' (initial estimate) versus 'Actual Time' (logged work) for each sprint.6c8b4516-79e3-4bfd-a6a7-5f392ce1e845.png

By leveraging Time & Cost Tracker's capabilities, you can obtain accurate sprint-level time tracking data, even with task migration and mid-sprint additions. This will help you confidently assess your team's estimation accuracy and identify areas for improvement.

Feel free to reach out if you have any more questions or need further assistance!

0 votes
Logan Mulderrig April 22, 2024

Try using Reports by Jira: https://www.atlassian.com/software/jira/features/reports

If that doesn't work, you may have to create a Dashboard in Jira, or use Confluence to store a lot of Advanced Search Jira filters. If this is the case, please include what fields/values you have access to on your tickets, with screenshots, etc.

ganna_kyselevych April 22, 2024

Reports in Jira do not work because I need statistics by assignee, and these reports do not cover it.

Logan Mulderrig April 22, 2024

Please include what fields/values you can access on your tickets, with screenshots, etc.

ganna_kyselevych April 23, 2024

Basically, I can add whatever is needed, coz I have rights of administrator.
Screenshot at Apr 23 11-16-05.png

Logan Mulderrig April 23, 2024

If only one person does work on any given ticket, you can make this happen using Jira native (I can elaborate if needed).

Although this has been an ask of Atlassian for years, you must employ one of the time-tracking third-party plugins for most workflows. You can try them for free before paying.

Logan Mulderrig April 24, 2024

Hi @ganna

I believe your problem can be solved unintendedly by using Jira native or by purchasing a third-party plugin (a demo is available)

Here is a post describing this: https://community.atlassian.com/t5/Jira-Software-questions/Re-JQL-Query-for-Summing-Completed-Story-Points-Per-Assi/qaq-p/1051239/comment-id/336443#M336443

Arthur French
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 21, 2024

Hi @Logan Mulderrig,

I'm also running into this issue, would you mind elaborating? Only one person works a ticket for us, so your solution may work.

Thanks,

Arthur

Logan Mulderrig August 21, 2024

@Arthur French If your users enter their time on each and every ticket, you can use use Atlassian macros in either Jira Dashboards or Confluence yo track Time Spent vs Estimated Time

You will need to make a filter of the users being tracked and the time frame you want the data for; either the last X weeks or from X date to X date.

Then you just compare the two pie charts.

However, this is contingent on users accurately inputting their Time Spent values, which will be a problem even if you buy the multitude of plug-ins available.

Screenshot 2024-08-21 at 1.32.48 PM.png

Arthur French
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 21, 2024

@Logan Mulderrig  Ahh thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events