Timesheet Report provides a timesheet table and a view of the worklogs in a structured form, summarized by Project, Issue and User.
Grouping Data
Group data in your reports to help you structure your information in a meaningful way. With the Group by filter Issues can be grouped by Project, Issue and User in any order. You can also display each worklog as the bottom level of your selected grouping.
To group data in a report:
Click the Group by box to display a list of possible choices. Select the groups you want to add.
To remove a level of grouping, click Group by, and then click x to the right of the specified group level.
You cannot place other filters after the Worklog filter because it cannot be interpreted in the data hierarchy
Period
Each column in the timesheet represents a day, week, month, or quarter, depending on the option you select in the Period drop-down menu.
Timesheet grid
The timesheet grid will display the worklogs in a structured form based on what you selected as a Group by option.
Display in the columns:
In the Project, Issue and User column, the following will be displayed: Project Key, Issue Key, User display name
In the Summary/Description column, the following will be displayed: Issue Summary, Worklog description
In the Sum column, you will see the total time corresponding to the item in that row.
In the Total (current page) row, you will see the total time corresponding to the column.
Limits
Approval limits
The app will ask for approval in cases where the report results in a large amount of data which can slow down your browser and use a considerable amount of memory.
Number of columns (period) to approve is more than 1000
Number of rows (project, issue, user, worklog) to approve is more than 2000
Number of cells to approve is more than 100000
Total limits
With this amount of data, the app will not generate the report.
Maximum displayable column (period) is 4000
Maximum displayable row is 10000
Maximum displayable cell is 1000000
Export
You can export your search results from this section to Excel or CSV file.
The Export button will export the result of the last created report. You can select the logged time export format where you can select the time format that appears in the exported reports:
Default: logged hours will be exported in the configured time format in JIRAs Time Tracking settings (eg.: Pretty = 1 hour 30 min)
Seconds: logged time will be exported in seconds (eg.: 1 hour = 3600)
Hours: logged hours will be exported in decimal number format (eg.: 1 hour 30 min = 1.5)
Please be aware of that the total number of characters that a cell can contain in Excel is 32,767 characters. If one of the entries exceeds the number of characters, the export function will not work properly.