Time Spent in Excel Data is not the same from the Sprint Burndow

Thiago Cunha June 16, 2021

I'm trying to see how much time the team has spent in a previous sprint and also have number which I can rely. When I do the sum in excel it show a diferent number comparing to the sprint burndown. 

 

I know that the issues retrieved from the excel sums all of the worklogs from all of the sprints. I think that's is what giving me the wrong number. 

 

So, can you guys help me? what's the calculation in the sum of spent work in the sprint burndown from jira and how can I replicate it to the excel? 

Number from excel sum and number of the sum of the spent time in the sprint burndown report:

Captura de Tela 2021-06-16 às 18.41.17.png

2 answers

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 18, 2021

There is no way to help you with this, there is no information in the question to work with.

We need to know exactly what you are downloading into Excel (how you're downloading might be needed too) and what you think is in the sprint.

0 votes
Thiago Cunha June 16, 2021

Captura de Tela 2021-06-16 às 18.42.53.png

Suggest an answer

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

Atlassian Community Events