Jira log hour report using two dimensional filter

[RenukaPrasad R]

Hello Everyone,

I have built a Jira log hour report using two dimensional rich filter to list the team member names in Y-axis and dates in X-axis.

My requirement: Display Day wise total hours logged by every team member, For e.g., For Jira issue number 1234; User A had logged 2 hours on 1-Nov and 4 hours on 22-Dec and for the same Jira logged 2 hours on 23-Dec; the report should list them day wise;

Issue: Instead of showing log hours daywise, the widget aggregates the hours as 8 hours i.e., displays as 8 hours for 23-Dec and 0 hours for days from 1-Nov to 22-Dec.

Steps followed for report creation:

1. Jira filter created with team member names with date range 

2. Rich filter created

3. Added Two dimensional filter widget with following configurations

4. Horizontal breakdown:

Statistic type: "Updated"

Aggregations: Days

Time Range: 1-Nov-2025 to 31-Dec-2025

5. Vertical Breakdown

Statistic Type: "Assignee"

6. Values: Time Spent

Please assist if i am missing anything or for corrections needed in the above or let me know for any information needed.

P.S: I am advised to create a day wise report using available widgets and to go for paid or marketplace custom reports.

Thanks

Prasad

[Sebastian Krzewiński]

Hi @RenukaPrasad R 

IMO - Two dimensional filter is not a good way to create such report. You should consider any time tracking app to get similar report or get data via api and built it outside jira.

Regards,

Seba

[Anton from JetHeads_io]

Hey @RenukaPrasad R! 👋

JetTime is a third-party time tracking app that can do exactly this — group by users (Y-axis) and enable timesheet mode with day-by-day breakdown (X-axis). It'll show each worklog entry separately per day, not aggregated, so you'll see User A's 2 hours on 1-Nov, 4 hours on 22-Dec, and 2 hours on 23-Dec as distinct entries.

JetTime features:

• Time tracking & timesheets with improved Log Work UI and timers
• Day-by-day timesheet reports with grouping by user, project, or date range
• Cost tracking with custom financial fields
• Custom metrics (mileage, materials, activity types, etc.)
• PDF & Excel export for reports
• Runs fully on Atlassian infrastructure, so data stays inside Atlassian Cloud

👉 JetTime on the Atlassian Marketplace
— Anton, JetTime founder

[Fatma Uzundemir from The Starware]

Hi @RenukaPrasad R

Welcome to the community ! 

You can build your own solution using Jira APIs or alternatively explore Marketplace add-ons. If you are open to using third-party apps and are looking for a solution that provides detailed and flexible time tracking reports, I would recommend the WorklogPro -Timesheets for Jira.

🌱 With WorklogPro - Timesheets for Jira, you can: 

• You can create real-time, customizable reports. You can analyze these reports by grouping, categorizing, and aggregating the data as you wish.
• With CSV import/export support, you can easily integrate your data into the application or export it for external use.
• You can use personalized timesheets on dashboards for any date you choose.
• In addition to the timesheet view, calendar and chart views are also available.
  
  

🍀 To learn more, feel free to contact me or explore the application through the Atlassian Marketplace link I’ve provided. 🍀 

---

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

[Rahul_RVS]

Hi @RenukaPrasad R 

Welcome to the community !!

You can use Jira API's to create create your own solution or as suggested by Sebastian, look for a mktplace add-on. If you are open to try out an app for detailed time tracking reports, you can try out

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

[Janis Plume _eazyBI_]

Hi,

eazyBI Reports and Charts for Jira is another app that allows creating such reports (and a lot of other things). You may wish to check a dashboard from our public demo account to see what kind of Time tracking reports are possible with eazyBI: https://eazybi.com/accounts/1000/dashboards/27385-time-tracking

Kindly,

Janis, eazyBI support