Table Chart Report

Owned by Derya Özdemir
Last updated: Jul 11, 2023
6 min read

This page is about JEP Cloud. Using Jira On-Prem? Click the On-Prem button above.

Overview

The Table Chart presents the time tracking data in a tabular format, allowing you to analyze and compare different categories or time periods easily. The report consists of multiple columns representing different aspects of the time tracking data.

By understanding the column descriptions and interpreting the data, you can gain valuable insights into time allocation and make informed decisions to optimize productivity and resource management.

Use the Table Chart report, if you…

  • Need a detailed and structured view of the time tracking data.

  • Want to compare and analyze time spent on different categories or tasks.

  • Need to track time over specific dates or periods and identify trends.

  • Want to filter or sort the data based on specific criteria for a more focused analysis.

Anatomy of a Table Chart Report

Let’s examine this type of report through an example.

Example: A user has created a project-based (Mobile Dev) report showing the duration each assignee spent on an issue.

1. Issue information – This part shows the Issue, its Summary, Status, Reporter, Assignee, and Priority. All the important information regarding the issue is listed here.

2. Total Time Spent (On Summary Table) – This shows the total time spent on the issues by all assignees. By default, it goes from the most time spent to the lowest, showing you the tasks that took the most time on the first page. If you want to see the issues that were resolved the most quickly on the first page, click the Sorting icon.

3-4. Columns (Main, Sub) – This is where the real action happens. Depending on your selection, you’ll see the duration data in a multi-dimensional format that highlights the most important information.

(Main): The Main selection is shown at the top. In this case, it’s Status.

(Sub): The Sub selection is shown below the Main selection. In this case, it’s Assignee.

5. Time Spent (On Column) – This shows the total time spent on the issue by the assignee. You can view the duration here, or you can go to Layout Settings to change its position.

6. Time Spent (In Row) – Here, you can see the sum of all durations based on each category.

Creating a Table Chart Report

  1. Go to Apps from the header menu, then click Enhancer Plugin for Jira.

  2. From the sidebar, click Time Tracking Report.

  3. Select the report type as Table Chart.

  4. Pick the calendar you want to use in the report.

  5. Select Filter Type to limit the scope of your issues by utilizing either Project, Issue Filters, Sprint, or JQL.

  6. To choose which information will be displayed on the report, pick Columns (Main, Sub). The Main category you pick will be displayed at the top of the columns, and the components of the Sub category will be listed below them. Accordingly, you can display Assignee, Reporter, and Status data.
    While selecting, you can also use the chevrons to switch the places of the categories.

  1. Click Generate to create your Time Tracking Report.

Tada! Your report should look something like this:

 

Configure the Report Layout

After creating the report, click Layout Settings to configure how it looks.

1. Row Settings

Here you can enable row coloring to change the color of each column (Main, Sub, Total Time Spent). Additionally, you can customize the categorization logic based on your desired completion time thresholds and the name of the categories by clicking the cog icon next to the column configuration. Check out the example below

In this example, we’ve configured the Main column as:

  • Issues completed within 0 to 2 days are categorized as "ACHIEVED".

  • Issues completed between 2 and 5 days are categorized as "WARNING".

  • Issues completed after 5 days are categorized as "FAILED".

2. Issue Settings

These refer to the fixed and issue-related parts of your report. Here, you can select which issue fields to enable or disable, and where you want the Total Time Spent summary to appear in the report (On Column, In Row, On Summary Table).

To better understand the Total Time Spent positions, check out the table below:

Position

 

Position

 

On Summary Table

On Column

In Row

 

3. Column Settings

Here you can customize the data that appear in the columns. Select how elements such as Assignees will be displayed (with avatars or not), as well as which ones to include in the report. Based on your Columns: (Main, Sub) selection, you can create assignee, status, and reporter groups. You can make different configurations for different parts within the Main selection and Sub selection categories.

For example, you could group different statuses in the Main selection depending on your use case. Check out an example of how to do that below: