Table
This topic describes how to configure the Table component, which displays data in a tabular format.
Step 1: Configure fields
In the data analysis report workbench, drag the Table component from the Chart pane to the canvas on the left.
Below the Data pane, select a metric type.
Original: Indicates the original metric data.
Daily: Indicates the derived metric data.
To configure the data displayed in the component, drag one or more fields from the Data pane to the configuration boxes on the Field tab in the Chart pane.
Parameter
Description
Column header
The table uses the selected field names as column headers.
You can add up to 200 fields.
Filter
Add time, text, or numeric fields and configure filter conditions to display specific data. For more information, see Configure fields for a metric card.
(Optional) On the Fields tab, in any configuration box other than Filter, hover over a field and click the down arrow icon
to perform the following operations.Operation
Description
Rename
Renames the field.
Sort
Options: No Sort, Ascending, or Descending.
NoteThis feature is only available for time-based fields under business time.
Data format
Sets the display format for numeric values, such as integer, decimal, percentage, or a custom format.
For example, if you choose percentage, a value of
12.34is displayed as1234%.NoteThis feature is only available for numeric fields.
Aggregation
Options: sum (default), average, count, maximum, minimum, or distinct count.
The selected aggregation method is displayed next to the field name.
NoteThis feature is only available for numeric fields.
Step 2: Configure styles
On the Style tab in the Chart pane, configure the display styles.
Parameter | Description |
Chart title | Configure the visibility and text of the chart title. |
Chart description | Configure the visibility and text of the chart description. By default, it is hidden. |
Pagination | Set the maximum number of data rows to display per page. Options: 10 rows/page, 15 rows/page, or 30 rows/page. |
Step 3: Configure Analysis Limits
On the Analysis tab below the chart bar, configure the maximum number of rows for data loading and analysis. The value range is 10 to 999,999 rows.