I'm facing some issues with my Jira excel export. The original estimated hours are not aligned with the number of hours that is issued by the assgines in the backlog.
For instant I'am obtaining 350 hours in the exported CVS file while in the backlog the number of hours is 500. This makes the export form Jira not accurate and relaiable.
What can be the reason for this differences?
Hi Rabia and welcome to the community.
Just to verify, you have these fields for the time reporting
Original Estimate: Which is your original estimate as assigned for the issue in the backlog
Remaining Estimate: Which is your adjusted estimate (when someone reports they can also adjust the time remaining)
Time Spent: Which is the total that someone has reported time for.
All of these also have fields that have a Σ sign before them (Σ Original Estimate, Σ Remaining Estimate, Σ Time Spent): These are the same but sums up with sub-tasks for the issue.
So one thing that may cause the difference is that in the issue you are looking at the original estimate while the report may use Σ Original Estimate.
Another might be that you are looking at original estimate versus remaining estimate.
Thank you for the reply.
I am exporting the original estimate which is the original estimate as assigned for the issue in the backlog and I'm comparing that with the original estiamte in the backlog. But still I'm facing discrepancies, the original estimate in the exported file is way lower than the equvailent original estimate in the backlog.
To get to the bottom of this, you will need to compare your backlog items to the CSV export items, and there are some quite random questions to ask:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events