Pivot Worklog Reports
Pivot Worklog Reports
Breadcrumbs

What is Pivot Worklog Reports?

GG-Logo---40x40px.png The Worklog Reports & Timesheets gadget is available either through this standalone app or as part of Great Gadgets for Jira, the complete bundle that provides a broader collection of dashboard gadgets in a single app.

Pivot Worklog Reports is a Jira dashboard app that helps Scrum, Kanban, SAFe®, ITSM, project, service, and business teams analyze and report on the time logged in Jira.

Turn Jira worklogs into detailed timesheets, multidimensional pivot reports, heatmaps, and charts. Track individual and team effort, understand how time is distributed across projects and work items, review worklog comments, and create weekly or monthly summaries without manually exporting the data to spreadsheets.

The app helps you answer questions such as:

  • How much time has been logged during a selected period?

  • Who logged time, when, and on which work items?

  • How is the team’s effort distributed across projects?

  • Which epics, initiatives, or work items consume the most time?

  • How much time is spent on different work item types, priorities, or statuses?

  • How does logged effort change from one week or month to another?

  • What percentage of the total logged time belongs to each project or team member?

  • Which comments were added to individual worklog entries?

  • How is effort distributed across team members?

  • Which worklogs should be reviewed for internal reporting or billing purposes?

Key features

Detailed timesheets and summarized reports

Use the same gadget to create both detailed worklog reports and high-level effort summaries.

Detailed reports can show individual worklog entries together with their authors, dates, time spent, comments, and related Jira fields. Summary reports can aggregate worklogs by team member, project, work item, week, month, or another relevant dimension.

Multiple report formats

Display worklog data as:

  • Regular pivot tables

  • Table heatmaps

  • Row heatmaps

  • Column heatmaps

  • Pivot charts

Multidimensional drag-and-drop reporting

Create reports by dragging selected fields into the Rows and Columns areas.

Multiple fields can be placed in the same report, allowing you to analyze Jira worklogs from several perspectives.

Multiple data sources

Create worklog reports using work items returned by:

  • Saved filters

  • JQL queries

  • Epics

  • Portfolio-level work items, such as initiatives or themes

Saved filters and JQL queries can include work items from multiple projects or teams, making it possible to create consolidated reports for departments, programs, customers, or broader delivery initiatives.

Flexible reporting periods

Choose which worklogs should be included using options such as:

  • Custom start and end dates

  • A configurable number of days back from the current date

  • All worklogs recorded from a specific date onward

  • The current calendar month


These options support both fixed reporting periods and rolling reports that remain current as time passes.

Worklog-specific fields and Jira fields

Build reports using worklog-specific fields such as:

  • Worklog Author

  • Worklog Date

  • Worklog Time Spent

  • Worklog Comment

You can combine them with Jira work-item fields such as:

  • Project

  • Status

  • Priority

  • Work Item Type

  • Assignee

  • Epic or parent hierarchy

  • Other supported custom fields

This allows you to understand not only how much time was logged, but also where that effort was invested.

Ready-to-use report presets

Use a predefined report as a starting point or select Custom to build a report from scratch.

Available presets include:

  • Table Report: Worklog Comments by Author: Displays individual worklog entries grouped by author, including the date, time spent, and comment associated with each entry.Table Report:

  • Monthly Worklog Total by Team Member: Displays the total time logged by each team member, grouped by month.

  • Pie Chart: Who Worked the Most in Each Project: Visualizes how logged time is distributed among team members and projects, helping you identify the largest contributors.

  • Stacked Column Chart: Monthly Hours Logged by Person: Shows the hours logged each month, split by team member, making it easier to compare individual contributions and changes in effort over time.

Selecting a preset automatically configures the relevant settings, which you can then adjust to match your reporting needs.

Flexible worklog filtering

Use additional filters to narrow down the worklogs displayed in the report.

You can filter the results using fields such as:

  • Project

  • Work Item Type

  • Assignee

  • Priority

  • Status

  • Supported custom fields

This allows you to create focused reports for a specific project, team, customer, category of work, or reporting purpose.

Configurable calculations and summaries

Calculate and summarize worklog data using options such as:

  • Worklog or work-item count

  • Sum of Worklog Time Spent

  • Sum of other supported numerical fields

  • Totals by row or column

  • Percentage of the grand total

  • Average values calculated using all cells or only non-zero cells

This supports both detailed time analysis and high-level effort reporting.

Subtask support

Include subtasks associated with the work items returned by a saved filter or JQL query.

This provides a more complete view when team members log time directly on subtasks rather than on their parent work items.