Generating Sprint Worklog Reports by Time Spent Within Sprint Period

Rohith k December 11, 2024

Hi Team,

Greetings of the day!!

We are seeking sprint worklog reports that detail the time spent within the current sprint period. It is important that we exclude any time logged on issues from previous sprints. Additionally, we require the time tracking to be reported separately for each Collaborator.

For example
, consider we have 10 tickets in Sprint A. During this sprint, we logged time for all the tickets. However, 7 of these tickets have been closed, while the remaining 3 have been moved to a new sprint called Sprint B. In Sprint B, we do not want to include the time spent on those 3 tickets from Sprint A; instead, we need to capture the time spent on these tickets as logged in the current Sprint B.

Also, we need to track the time spent for each collaborator.

Is there a way to generate the sprint reports to reflect this requirement?

Thanks,
Rohith.

1 answer

1 vote
Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 11, 2024

Hi @Rohith k 

For detailed worklog reporting if you would be interested in a mktplace app, you may want to try out our mktplace app. Other option is to use Jira Rest API's to build your own custom solution.

Worklogs Time Tracking & Timesheets

With this add-on, you can easily view time entries for multiple issues day wise grouped by in a single view. Also for your requirement as shown in the screen grab below, you can filter the time spent between your sprint date range.

(Disclaimer: I work for RVS, the vendor for this app)Worklogs - date range filter.PNG

Rohith k December 11, 2024

Hi @Rahul_RVS_Support 

I am trying to fetch the data with this addon, I am unable to see the result. Attached Screenshot for reference.
When I am trying to filter project name and sprint, I am getting no result found. 

Screenshot 2024-12-11 222321.png

 

Thanks!!

Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 11, 2024

Hi @Rohith k 

Thanks for trying out the add-on.

Can you pls share your email id at support@rvsoftwares.in

I will set up a quick zoom call with my team tomorrow to look at the issue.

Thanks

Rohith k December 11, 2024

Hi @Rahul_RVS_Support 

I have sent an email to support@rvsoftwares.in

Thanks for your help!!

Like Rahul_RVS_Support likes this
Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 12, 2024

Thanks Rohith for joining the call with our support team.

I believe the issue was resolved.

Pls do reach out for any further queries.

Thanks

Rohith k December 12, 2024

Hi @Rahul_RVS_Support 

I can generate the reports now; however, they are not producing the expected results. We need a report structured as follows:

Example: For ticket Jira-123, User-A is the assignee and recorded 2h of work on this ticket. In some cases, User-B may also log time spent—let's say 4h in this instance. Therefore, the total time spent on this ticket would be 6h. It’s important for us to see a breakdown of time spent by each user who worked on the ticket (Worklog author by time spent). Currently, when we pull data based on assignee and their logged hours, it appears that all 6h are attributed solely to User-A.

Is there any way to extract these types of reports? Alternatively, could you recommend any third-party add-ons that might help us obtain them?

Thank you!

Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 12, 2024

Hi @Rohit

You can use the following filter criteria to get detailed break down : "Category - Author", "Group By - Issue" . This will provide the required data. As shown in the screen shot below, for issue AG-117, 2 users have booked time.

Worklogs-Multiple Author- Same Issue-New.PNG

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