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