Using Tables as Visuals
Use a table visual to see a customized table view of your data.
To create a table visual, choose at least one field of any data type. You can add as many columns as you need. Plus, you can add calculated columns.
The icon for a table is as follows.
Table Features
Table visuals don't display a legend. You can hide or display the title on a table. You can also hide or display totals, and choose to show totals at the top or the bottom of the table.
To understand the features supported by tables, use the following table.
| Feature | Supported? | For More Information |
|---|---|---|
| Changing the legend display | No | Customizing the Visual Legend |
| Changing the title display | Yes | Customizing a Visual Title |
| Sorting | Yes | Sorting Visual Data in Amazon QuickSight |
| Calculated fields and aggregations | Yes | Changing Field Aggregation |
| Adding drill-downs | No | Adding Drill-Downs to Visual Data in Amazon QuickSight |
| Showing or hiding totals | Yes | Using Totals on a Table |
| Showing or hiding columns | Yes | Showing or Hiding Columns on a Table |
| Conditional formatting | Yes | Adding Conditional Formatting to Visuals |
Showing or Hiding Columns on a Table
You can show or hide columns on a table. To hide a column, choose the field you want to hide, then choose Hide column. To display any hidden column, choose any column, then choose Show all hidden columns.
Tabular reports can display up to 200 columns.
Transpose Columns to Rows
You can transpose columns to rows and you can transpose rows to columns. To transpose
columns and rows, choose the transpose icon near the top right of the visual.
It has
two arrows at a 90 degree angle:
.
Tabular reports can display up to 200 columns.
Using Totals on a Table
You can show or hide totals on a table. To access the option to Show Totals or Hide Totals, use the on-visual menu at the top right of the visual.
You can show totals at the top or the bottom of the visual. Use the on-visual menu to access the option for Format visual. If you enable Show Totals, you will see the options for Top and Bottom locations.
Creating a Table Visual
Use the following procedure to create a table visual.
-
On the analysis page, choose Visualize on the tool bar.
-
Choose Add on the application bar, and then choose Add visual.
-
On the Visual types pane, choose the table icon.
-
From the Fields list pane, choose the fields that you want to use. If you want to add a calculated field, choose Add on the application bar, and then choose Add calculated field.
To create a non-aggregated view of the data, add fields only to the Value field well. This shows data without any aggregations.
To create an aggregated view of the data, choose the fields that you want to aggregate by, and then add them to the Group by field well.
