Create report that will show difference between estimated and real hours in sprint for etch person

[Anton_kolesnyk]

Hello there,

Please help with a report that will show the difference between the estimated and actual sprint hours for each person, is it possible to implement this with the resources of Jira, or do I need some additional plugins?

Regards,

[Vamsi Kandala]

Hi @Anton_kolesnyk

Welcome to the community!

Please refer these which was asked before:

https://community.atlassian.com/t5/Jira-questions/Chart-to-show-estimated-time-vs-actual-time/qaq-p/669185

https://community.atlassian.com/t5/Jira-Software-questions/Sprint-Reporting-Planned-Vs-Actual/qaq-p/1807947

Hope this helps.

Thanks,
Vamsi

[Anton_kolesnyk]

Hi, thanks for the welcome, I have already read the advice above and tried to configure it through the dashboard, but I am interested in the implementation through JQL or tables, is it possible to search by person in the sprint so that I can see the difference between the estimated and actual sprint hours?

Thanks,

[Nic Brough -Adaptavist-]

Are your hours the sprint statistic?  Feeding into the sprint's velocity?

[Anton_kolesnyk]

Actually what I am looking for is a way to pull estimated hours vs logged hours per each ticket. This info is needed to asses estimations accuracy. Could you please give me a hint on how it could be done ?

[Nic Brough -Adaptavist-]

Jira does not have a per-user report like this (because it's not how you should be doing scrum, and it's actually illegal to do user monitoring like this in some of the marketplaces (countries) that Atlassian sells into).  The closest you can get is a "workload report", from the project's reporting panel, which is aimed at showing you who is currently over or under loaded with work so you can re-allocate if necessary.

Measuring it by issue is, of course, absolutely fine, so it then comes to what report you actually want from it.

The most simple one would be the issue navigator, where you can run a search for a pile of issues , and choose to display the ΣOriginal Estimate, ΣProgress, ΣRemaining Estimate and ΣTime spent fields (I use the Σ fields so that I can ignore sub-tasks in non-agile projects).  

But I quite like putting in a calculated field for "estimate variance".  I don't use anything as simple as this, but if you create a numeric field that contains "ΣTime spent * 100 / ΣOriginal estimate", you get a ratio (a simple percentage) that can be easily sorted and searched to find issues that went under or over.  It's much the same as the progress field, but easier to report on, and I only calculate it for "done" issues (resolved)

[Anton_kolesnyk]

Could you please share with a query example for that if you have any. It would be really helpful:) Thank you in advance

[Nic Brough -Adaptavist-]

I'm sorry, I do not understand the question.  Query for what?

[Anton_kolesnyk]

I'm sorry, my mistake, I didn't find a calculated or numerical field in the field settings, can you tell me how to do what you described above?

[Nic Brough -Adaptavist-]

Usually, I use a Scriptrunner scripted field (I work for Adaptavist, so I usually have it installed)

[Anton_kolesnyk]

That's great, we use Scriptrunner too, could you help with this?

[Nic Brough -Adaptavist-]

Start from https://library.adaptavist.com/entity/scripted-field-that-sums-up-all-the-values-inserted-in-a-number-field ; it shows the basics of adding up numbers and you can easily replace what it looks at with a couple of reads of the fields.

[Miron Ivano _Timescale_]

Hi @Anton_kolesnyk 

There many time tracking app that can do what you need. They have customisable reports. Many organization want to track these two indicators mainly to asses their teams estimation accuracy. There are teams that even have actual KPI's on those indicators. Still at the end is a question if you have this information does it give you extra tools to improve your teams performance?

Still what you can check is: Timescale for JIRA.

You can see the comparison on Projects Level or on User Level. I think soon there will be on Sprint level

You can always contact Timescale