Tables are based on at least one metric and one attribute. They contain a table of the raw data from the data source selected for the visual. Tables are supported by all Composer data connectors.
In addition to tables from raw data, Composer supports pivot tables. See Pivot Tables.
Data from Fusion data sources can be used in tables. However, Composer recommends that you initially use a subset of fields from Fusion data sources on tables of raw data to limit the load on Composer's query engine and improve its performance. You can change the subset in data source configurations and add additional fields, later, as needed while working on a dashboard.
Number field formatting in tables is based on the formatting specified for the numeric field in a data source configuration. Time field formatting in aggregated tables is based on the granularity specified for the time field in the data source configuration.
If you want tables for a data source to support live mode and data playback, be sure that the data source includes a time field and that it meets the requirements for live mode and playback. See Live Mode and Historical Playback.
Live mode and historical playback do not work for tables when the table is grouped.
When you first create a table, the default settings specified in the data source configuration are used to create the table. You can modify the table fields, enlarge or decrease the size of the columns, rearrange the table columns, and sort the data by the column headings. See the following topics:
- Configure Default Table Settings
- Configure Settings for a Specific Table
- Add or Remove Table Columns
- Move Table Columns
- Change Column Widths
- Group and Ungroup Table Data
- Apply Even Time Intervals on Tables
- Change Time Field Granularity in Tables
- Change Metric Aggregation in Tables
- Change Table Pagination
- Sort Data in a Table
- Table Context Menu
You can use Keyboard Controls on the Table Settings sidebar instead of a mouse.