(v24) Tables

Tables

This applies to: Visual Data Discovery

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 Symphony data connectors.

In addition to tables from raw data, Symphony supports pivot tables. See Pivot Tables.

Data from Fusion data sources can be used in tables. However, Symphony recommends that you initially use a subset of fields from Fusion data sources on tables of raw data to limit the load on Symphony'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. You can edit the formatting for specific fields in a table by editing the numeric format. 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.

Note: Live mode and historical playback do not work for tables when the table is grouped.

After you create a table, you can modify the table fields, enlarge or decrease the size of the columns, rearrange the table columns, change the formatting of numeric fields, sort the data by the column headings, and add custom metrics and derived fields. See the following topics:

• 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

• Format Numeric Table Data Using the Table Context Menu

• Format Time Table Data Using the Table Context Menu

• Table Context Menu

• Maintain Custom Metrics

• Maintain Derived Fields

Note: You can use Keyboard Controls on the Table Settings sidebar instead of a mouse.