Table View

View type: Table

You can view the results of your JQL query as a table, where you can select the columns that are displayed.

Using the table view, you can display results as:

• Calculated columns

• Group of results

• Aggregation of results

Open

Calculated columns

Calculated columns are a powerful way to add data to a table.

In this field, you find the Customer Portal column that is not natively available in Jira.

Customer Portal

The column provides a link to the issue in the corresponding Customer Portal link for users of the Customer Portal.
Use the Customer Portal when you share a dashboard with customers so that they can access the ticket.
For more information see:
Manage Access of Users and Organizations to the Jira Service Management Customer Portal

The example shows how the Customer Portal column links to.

Instead of:

the column links to:

Group results

Group results by selected columns

If you are familiar with the GROUP BY statement in SQL, you can choose how to group the results of your JQL query .
NOTE
When you select to group the results from the previously selected columns, the result rows are split into groups, based on their values. This means that only one row is displayed for each of the groups.

Pay attention to select the columns based on the results that you want to display for each group

EXAMPLE

If we filter the previous list of issues by the column Status, the results show only two rows, one for the status To Do and other for the status Done.

Open

Selecting the columns: Status, Assignee and Project, the resulting list displays three rows.

The grouping of columns is typically combined with aggregations, which moves us to the next section.

Aggregations

Aggregations are also common in the SQL domain. These functions get the values of grouped rows as the input of that function to return a calculated value.

This gadget supports five functions:

• Count. It returns the number of rows in that group.

• Sum. It returns the addition of the sequence of the numbers of the group.

• Min. It returns the smallest value of the range of values of the group.

• Max. It returns the largest value of the range of values of the group.

• Mean. The arithmetic mean, it sums the values of the grouped rows and divides the result by how many rows are being averaged.

For example, if we want to calculate the mean of the story points