How to create a report based on the time tracking

[Marios Theodoulou]

Dear team,

Our In House Design team needs to create a report including the time spend (time tracking). In the process of creating this report it says that i need to access JQL.

Could you please assist?

Thank you in advance.

Kind regards,

Marios

[Anton from JetHeads_io]

Hi @Marios Theodoulou! 👋

Jira’s native reports often require JQL, which can be tricky and time-consuming to set up for many users.

If you want a simpler and more user-friendly way to create detailed time tracking reports without writing JQL, you might find JetTime app very helpful. It offers easy report building with flexible filters and grouping — no JQL needed for most cases.

Feel free to check it out for a smoother reporting experience!

👉 JetTime on the Atlassian Marketplace

— Anton, from JetTime

[Vinubabu _Vinu_]

Hello @Marios Theodoulou I presume you are looking to export the time logged on a ticket. If so, you can use the "Time spent" column in the filter results and export it.

Run a JQL to search for the work items that you want to export. In the column view add the "Time Spent" column. You can export this as a csv or use the jql in a dashboard report.

Best, Vinu

[Michał Kowalewski_SolDevelo]

Hi @Marios Theodoulou 

If you are looking for a tool that will allow you to quickly check the logged time of your users then it is worth trying out Worklogs - Time Tracking and Time Reports - marketplace app developed by my team.

You do not need to know JQL to view the logged hours report. Just select your filters and time period and the report will generate in a flash.

Would you like to see app's demo? Feel free to book one, or contact us via customer portal.

Michał,
SolDevelo Team 

[Rahul_RVS]

Hi @Marios Theodoulou 

For detailed time tracking reports if you would be interested in a mktplace app, pls take a look at

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily view all time entries for multiple issues day wise / month wise, user wise, grouped by in a single view. Also filter worklogs created between a date range as shown below. 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 Timesheet screen. With Calendar view and Board view

(Disclaimer: I am part of the app development team)

[Natalia_Kovalchuk_SaaSJet_]

Hi @Marios Theodoulou!

You can use this JQL query to find all tasks in the Design project where time has been logged:

project = "Design" AND timespent > 0

This will display all work items with recorded time spent.

For example, you will get such a report:

If you want reports that are both detailed and simple to use, try the Time & Cost Tracker for Jira app from my team.

It allows you to:

• View how much time is spent on different tasks, depending on their status (e.g., “In Progress” or “In Review”).
• You can make reports that are clear and detailed without ever writing JQL.
• You can filter tasks by the person assigned, the project they belong to, their current status, or a specific time period.
• You can export reports quickly.

For example, you can use the filter by projects, set the specific date range, and get such a report: 

You will receive a list of work items, view their projects, and see the time spent on each. 

You can export this data easily for further analysis.

[Dmitry Astapkovich _Colined_]

If you are open to 3rd party apps, take a look on Pivot Report we develop. It covers tons of reporting needs, including time tracking report based on JQL:

You can check this demo report here: https://demo.colined.com/plugins/servlet/pr/report?report=122