How to automate sprint report?

ankur_gupta_contractor

Hi

I am trying Jira automation to generate sprint report for user hours and tasks based automatically when sprint ends. Have anyone know any way to automate this process?

JIRA automation, we would need the report generated to include two things: 1. how many tasks each user finished during the sprint, 2. How many hours each user spent in the sprint

Thanks

Sam Harding

Hi @ankur_gupta_contractor 

Collating this information on a per user basis is tricky, to the point of not being possible/advisable. You can however get this information on a per worklog and issue basis to put into a report.

For example, if you were to trigger on "Sprint Completed", then do a "Lookup Issues" with your JQL as "Sprint = {{sprint.name}}", you now have a list of all the issues which were part of that sprint.

Then if you wanted to send or generate a report with some information about work logged or issues completed, you could use a smart value such as

Stats on {{sprint.name}}

{{#lookupIssues}}
Time spent on {{key}}:
{{#worklog}}{{author.displayName}}: {{timespent}}}}{{/}}
{{/}}

Complete Tasks: 
{{#lookupIssues}}{{#if(equals(status.statusCategory.key, "done"))}}
{{assignee.displayName}}: {{key}}{{/}}{{/}}

This will give you some information in the format

Stats on My Latest Sprint

Time spent on ISSUE-1:
Alice: 1h
Bob: 2h

Time spent on ISSUE-2:
Alice: 2h
Bob: 3h

Complete Tasks:
Alice: ISSUE-1
Bob: ISSUE-2

Unfortunately, this does mean the work logged information is split across each individual issue, but it does allow you to somewhat get the relevant information out of the sprint.

I hope that helps

Sam