Create a report or filter to view Worklogs

[Jose Souza]

Hi everyone,

I’m trying to create a filter/report/dashboard (whatever works) where I can see the worklogs and the time spent on a specific ticket. I believe that dashboards don't allow me to manipulate the data as needed. Has anyone needed this type of data before? If so, how did you create a visualization for it?

Thank you very much!

[Alexey Pavlenko _App Developer_]

Hi @Jose Souza  ,

There is no native JIRA gadget for that, unfortunately. You can try the app I developed - Multi-team Metrics & Retrospectives. With it, you can get this view:

Or this view:

Best regards,
Alexey

[Rahul_RVS]

Hi @Jose Souza 

If you are open to try out an app for detailed time tracking reports, I can suggest the one we have developed 

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily add time tracking reports as a dashboard gadget. Main features of the app -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Time sheet screen. With Calendar view and Board view

Disclaimer : I am part of the dev team

[Martins Vanags_eazyBI]

Hi Jose,

I'm Martins from eazyBI support.

If you consider using Atlassian Marketplace apps, eazyBI very well integrates with Tempo Timesheets, and you can also analyze Jira native worklogs (depending on what your time tracking provider is in Jira)

With eazyBI, you could create reports and analyze Time tracking measures:

https://docs.eazybi.com/eazybi/data-import/data-from-jira/time-tracking-measures 

Check a few demo reports with visualizations on the public eazyBI demo account.
https://eazybi.com/accounts/1000/dashboards/27385-time-tracking 

Using the measure "Hours spent", which accumulates the worklog hours from Jira, you can interact with the report using the feature "Drill through worklogs". It would show the worklogs (with details such as user, ticket and comment) from the particular report context on an additional pop-up screen.

Martins / eazyBI

[Gökçe Karaduman-The Starware]

Hi @Jose Souza

Unfortunately, Jira dashboards don’t support direct manipulation of worklogs.

If you’re open to using a third-party app, WorklogPRO provides a powerful solution for managing worklogs. It allows you to create detailed reports and dashboard gadgets to track time spent on specific tickets, giving clear visibility into worklogs.

By creating a Jira filter for the issues you want to track, you can use it in WorklogPRO’s Timesheet report gadget to display worklogs for any period. Its grouping capabilities let you organize worklogs by assignee, issue type, or other fields, providing multiple insights in a single report. You can also click on a worklog cell to edit or update the entry directly from the report.

WorklogPRO also includes a Work calendar gagdet,which displays worklogs in a calendar format for a clear overview over time. Worklogs can be managed and edited directly from the calendar view, allowing you to track, adjust, and organize entries without leaving the dashboard.

Disclaimer: I work for the vendor who developed this application.

[Gracjan Wesołowski _HeroCoders_]

Hi @Jose Souza 

Welcome to the community!

You might consider using time-tracking apps that in most cases have a customizable report of tracked time on issues.

I can recommend our Clockwork Automated Time Tracking & Timesheets Pro or Lite app, which allows you to track time for individual users across the projects, and this data using timesheets and create reports that can be configured in various ways using break-down and filtering options.

Using timesheets, you can create a report and filter it based on several options including, projects, issue types, issues labels, or other fields. You can choose a range for a whole year and break down the data by chosen fields. This information can be also exported to Excel files.

Please find below the sample of how the timesheet looks like:

If you have any questions, you can contact us at our help center.

Cheers!

Gracjan

[Michał Kowalewski_SolDevelo]

Hi @Jose Souza, and welcome to the community!

When it comes to displaying your team work logs on the dashboard, you may consider our app - Worklogs - Time Tracking and Reports. 

You can display different users, projects, custom fields, etc. Of course, you can log time into your Jira issues directly from the dashboard.

You can also add several different reports to your dashboard, for example, one gadget shows a table with your time logs and another shows your data in the form of a Pie Chart:

There are many possibilities that our application allows. We would be happy to meet with you and show you the application if you are interested.

You can book a demo session with us here.
We are also happy to answer any questions if you prefer to contact us through our portal.

Have a nice day!
Michał from SolDevelo🚀

[Mariia_Domska_SaaSJet]

Hi, @Jose Souza 

I'm Mariia from SaaSJet. 

I would also like to offer you to try an app developed by my team for your request: No-code Apps Creator. It is an AI-powered app that builds a custom dashboard and app through a simple conversation with AI.   

For instance, I wrote a simple prompt:

Create a dashboard widget that displays worklogs and time spent for selected Jira issues.
For each ticket, show:

• Issue key, summary, and assignee

• Total time spent

• Individual worklog entries (user, date, time logged, comment)

Add filters for project, assignee, and date range. Include a summary section that shows total time logged for all selected issues. Allow sorting by user or issue. Use a clean table or chart view for visualization.

And after a few minutes, I got my own dashboard.

You can also improve your custom dashboard and all through simple chat with AI.

I’d really appreciate it if you could give it a try https://saasjet.com/yyeb

[Mary from Planyway]

Hi @Jose Souza 

You're right that dashboards might not offer the manipulation you're looking for directly within Jira's native functionalities. Many users find themselves in a similar situation when needing to go beyond basic issue counts or simple time aggregates.

If you consider using plugins, I'd recommend Planyway for Jira. The tool covers 3 use cases: roadmapping, resource planning, and time tracking. As for time tracking, the app syncs with Time tracking field in Jira and processes the data into reports you may find useful. 

1. Go to Planyway's Reports section.

2. Set your date range.

3. Group the report the way you need.

4. Filter by issues.

5. If needed, the report can be shared by link or exported to Excel or PDF.

6. Today we're also adding a new feature. It'll make a report that compares tracked time vs estimate, plus shows remaining time. 

[CP]

If you want to use the default dashboard, only one or two of them can show time spent. I think the workload pie does.

If you are going to develop your own custom app, I have been able to get them via both a local C# app and an online Forge Dashboard gadget.

The endpoint I use is: /rest/api/3/issue/JIRA-123?expand=worklog

The "worklog" returns as an array of entries for that issue and you can see who saved what.

If you only need total time spent per issue, that is in the root level "fields" and is called "timespent". It's in seconds. But this doesn't tell you who saved it.

UI Kit 2 can be used to display it on the dashboard. It's much easier to use "timespent" totals due to the time it takes to load a bunch of issues. If you need the full worklog data, which is the only way to tell who saved what times, then my suggestion is you make use of Forge online storage and save totals per person per issue every time it runs and only actually query updated items, otherwise your gadget will eventually time out