---
title: "Table View"
canonical: "https://support.appfire.com/space/RDD/560661330/Table%20View"
format: markdown
---
## 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

![image](media://081a8238-f8f5-44be-9396-b2a317d36019)

### 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:  
[https://appfire.atlassian.net/wiki/spaces/RDD/pages/146309699](https://appfire.atlassian.net/wiki/spaces/RDD/pages/146309699)

The example shows how the Customer Portal column links to.

Instead of:

```
https://acme.atlassian.net/browse/ISM-12
```

the column links to:

```
https://acme.atlassian.net/servicedesk/customer/portal/1/ISM-12
```

### 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 <u>only one row is displayed for each of the groups. </u>

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*.

![image](media://3113cdf5-11cf-49c0-8877-af9e5f6adba2)

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

![image](media://a09f87e5-038e-4d96-84ab-c1829d332c4d)

![image](media://863f0cec-a8fa-4484-942f-7332608a4a15)

---