Jira report for pulling cumulative time spent for particular user.
Hi @Brightone Msengeti
you have a various more and less sophisticated tools available on the marketplace: https://marketplace.atlassian.com/search?query=worklogs
If you are fine with a mktplace app, to get this data, you can try out our plugin
Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs
The app provides the following features.
Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. You can filter based on worklogs time period as well.
Hi @Brightone Msengeti, if you're open to trying add-ons, I'd like to suggest you checking Planyway out. It's a 3-rd party app that was developed by my team. It has the Reports tab that shows tracked time on issues per user:
Planyway syncs with Jira worklogs. You'll see the total tracked time per user and can check time per each issue.
Hope you give it a try, feel free to ask any questions.
Regards,Tania
Hello @Brightone Msengeti
As an alternative, you can try Time in Status for Jira Cloud. With its reports, you can solve your issue easily.
Choose an Assignee time report. It shows how long each Assignee has been working on each issue. And in the "Total" column you can find the total time a particular person has spent on each issue.
Also, you can export a generated report to CSV or XLSX files.
It's developed by my team and is free for using up to 10 users. Please, let me know if you have any questions.
Hi @Brightone Msengeti,
here's another app that you might like: JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of advanced features, including the ability to group your issues by any issue field(s) and calculate sum-ups.
With these, you can build a view like e.g. this in just a couple of clicks:
This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.
I should add that JXL can do much more than the above: From bulk editing via copy/paste, to support for configurable issue hierarchies, or conditional formatting. More info at https://jxl.app. Any questions just let me know,
Best,
Hannes
Hi !I would recommend you our Worklogs - Time Tracking and Reports . Our app allows you to create a report based on Jira Time Logs and Jira issue fields including the custom ones. There are many possibilities to built your report. For example, you can check how much time each user spent on each project, issue type or customer.
You can chose to view the report as a table or graphic chart.Each report can be exported to an excel file, shared through a link or added to a dashboard in a Worklog gadget.Feel free to check it out in our Interactive Demo here.
Hey folks, here is a popular, best and free alternate not just for worklog generation, but is bundled with lot more cool features.
Jira Assistant for Chrome: https://chrome.google.com/webstore/detail/jira-assistant-worklog-sp/momjbjbjpbcbnepbgkkiaofkgimihbii
For other browsers and more details visit https://www.jiraassistant.com
Even best thing is, their is no need of any admin permission. Any user can easily install and start using it right a way.
I came across it by chance and using it from past 2 years. Its definitely worth a try.
@Brightone Msengeti
Better Excel Exporter for Jira Cloud comes with a built-in and dedicated Jira worklog report template. That automatically creates relevant pivot tables and pivot charts from the exported Jira worklog data.
It's integrated with Tempo Timesheets as well (among others), so you can build your worklog reports from Tempo-managed worklogs and metadata if you use Tempo Timesheets.
Find sample Excel worklog reports here >>A Jira Cloud worklog export tutorial with video here >>
(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)
It looks like you're new here. Sign in or register to get started.