Table

Updated at:

This topic describes how to configure the Table component, which displays data in a tabular format.

Step 1: Configure fields

  1. In the data analysis report workbench, drag the Table component from the Chart pane to the canvas on the left.

  2. Below the Data pane, select a metric type.

    • Original: Indicates the original metric data.

    • Daily: Indicates the derived metric data.

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

  4. (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.

    Note

    This 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.34 is displayed as 1234%.

    Note

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

    Note

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