Updated on 2025-05-20 GMT+08:00

Table

Tables use a structured layout of rows and columns to organize and present data, making it easier for you to identify and understand the relationships between different data points. This helps to make the information clearer and more comprehensible. This section describes how to create a table.

Prerequisites

Procedure

  1. On the Comps tab of the large screen page, click the text icon and click Table.
  2. Select the dataset to analyze from the Data area on the right of the dashboard creation page.
  3. Set the parameters on the Fields, Styles, and Interactions tab pages.
  4. Click Update on the Fields tab. The chart data is automatically updated.
    Figure 1 Table
  5. Click Save or Save and Publish in the upper right corner to save the large screen.
  6. In the Save Screen dialog box that appears, enter the large screen name and click OK.

Fields

  1. In the Data area on the right, select a dataset, and double-click or drag required dimension and metric fields to the corresponding areas on the Fields tab.
  2. Set a filter.
    1. Find the data field you need in the dimension and metric lists within the data column.
    2. Click next to the field you wish to filter and you will be directed to the filter settings page.
    3. Click OK.
      Table 1 Filter parameters

      Type

      Parameter

      Description

      string

      Condition

      Filter Mode: The options are Condition and Enumeration.

      Condition Type: The options are And condition and Or condition.

      Filter Condition: The options are Exact match, Contain, Start with, End with, Not match, Not contain, Null, and Not null.

      Enumeration

      Query Mode: The options are Single-select and multi-select.

      Filter Condition: The options are >, , <, , =, , Null, and Not null.

      Metric

      Condition Type

      The options are And condition and Or condition.

      Filter Condition

      The options are >, , <, , =, , Null, and Not null. You can select Before aggregation and After aggregation for data.

      NOTE:

      If you select Before aggregation, data is filtered before aggregation. If you select After aggregation, data is filtered after aggregation. For aggregation concepts, see Creating a Dataset.

      You can click Create Filter Condition to set multiple filter criteria.

      Date

      Range value

      Select a time range for filtering.

      Single value

      Set a single time for filtering.

      Condition

      You can select And condition or Or condition as the condition type and select filter condition like >, , <, , and =.

      You can click Create Filter Condition to set multiple filter criteria.

  3. Set sorting.
    1. Drag and drop required data fields from the Dimension and Metric (Indicator) areas under Data to the Sorting area.
    2. Click next to a field in the Sorting area and select a sorting mode. The sorting modes are Ascending, Descending, and Custom.
    3. To cancel sorting, click next to the sorting field.
  4. Set the maximum number of query results.

    Enter the maximum number of records that can be returned in the text box. The default value is 1000.

  5. Set automatic refresh.

    The auto refresh interval supports the following options: no refresh, 1 minute, 5 minutes, 15 minutes, and 30 minutes.

Styles

Table 2 Size/Position

Parameter

Description

W

Width of the target, in pixels.

H

Height of the target, in pixels.

X

Position of the target on the canvas, in pixels.

Y

Position of the target on the canvas, in pixels.

Opacity

Adjust the transparency of the target on the canvas using a slider or by manually entering a percentage. A higher percentage means lower transparency.

Table 3 Global Style

Parameter

Description

Table Layout

You can adjust the proportions of the table. The options are Automatic adjustment and Proportional distribution.

Pagination Display

You can set Rows, Font, Font Color, Font Size, Font Weight, and more of the table.

Filter

By selecting this option, appears in the table header, allowing you to filter the data.

Sort

You can sort the data in the following ways:

  • Sorting by dimension: Drag and drop dimension fields into the sorting slots to display them in the chart.
  • Sorting by metric: Metric fields in the sorting slots are not displayed in the chart by default. To display them, drag and drop them into the metric slots.

Export

After selecting this option, the Export Data and Export History buttons will appear above the table, allowing you to export the table from the large screen to your local host.

  • Export Data: Clicking Export Data will prompt you to enter a task name and storage period to create a table export task.
  • Export History: The created export tasks can be viewed on this tab. Clicking Download will export the table to your local host.
NOTE:
  • The Export Data and Export History buttons will be grayed out if the table cannot be exported.
  • Administrators, developers, and analysts have the permission to use this function, while read-only users cannot export the table.
  • Masked data cannot be exported. For details about how to set data masking, see Data Masking Rule.
  • When sharing and collaborating, the shared members need to have the permission to export the large screen to use this function. For how to grant the export permission, see Sharing a Large Screen.
  • All data can be exported, regardless of the number of records displayed in the table. For how to set the number of records, see Maximum Query Results.
  • The storage period can be customized through the maximum retention period in the import and export settings. For specific configurations, see Configuring an OBS Bucket.

Borderline

Set the weight and color of the table borders.

Table 4 Table Header

Parameter

Description

Show Table Header

Click this checkbox () to show the table header. Uncheck it () to hide the table header.

Header Row Height

Enter a value to set the height of the header row.

Background Color

Select a background color.

Alignment

Set the alignment of the header text, choose from Center Horizontally, Left, or Right.

Text

Set Font, Font Color, Font Size, and Font Weight.

Show Column Header Groups

You can set the table to display multiple rows of headers, with a maximum combination of 50.

  • Adding a group: Check this option and click . In the dialog box that appears, click + Add Group.
  • Naming a group: Click next to a created group and name it.
  • Adding content to a group: Drag and drop columns into a desired group.
  • Deleting a group: Click next to a group to delete it. The columns within the group will not be deleted.
  • Showing table header group: Click this option () to show the table header group. Uncheck it () to hide the table header group.
  • Changing group order: Drag and drop the groups on the header group page to change their order.
Table 5 Row Configuration

Parameter

Description

Row Height

Set the row height, the input value cannot be less than 45.

Background Color of Odd-Numbered Row

Click the color editor to set the background color of odd rows in the table.

Background Color of Even-Numbered Row

Click the color editor to set the background color of even rows in the table.

Background Color of Selected Row

Set the color of the row where the linked field is located.

Alignment

Row configuration alignment types include Center Horizontally, Left, and Right.

Automatic Line Break

Set whether to wrap text. When set, the cell content will automatically wrap when it exceeds the cell width.

Text

Set the font, font color, font size, and font type of the row.

Row Divider

Set the style, weight, and color of the row divider.

Table 6 Series settings

Parameter

Description

Select Series

Choose a series based on your alignment requirements for table headers and column content.

Auto Alignment

Check this option to enable alignment settings for table headers and content.

Table Header

Set the alignment for table headers. Alignment options are Auto, Align Left, Center, and Align Right.

Content

Set the alignment for table content. Alignment options are Auto, Align Left, Center, and Align Right.

Table 7 Parameters

Parameter

Description

Condition Format

Select Series: Select configuration fields based on the fields displayed in the chart.

Quick style.

  • Select a quick icon from the existing styles.
  • Color inversion: Turn on color inversion to swap the colors of the quick icon. Turn it off to restore the original colors.

Custom style:

  • Text
    • Condition selection: Choose between comparing with a fixed value or a dynamic value.
    • Filter Condition Types: Includes greater than, greater than or equal to, equal to, less than or equal to, less than, not equal to, greater than A and less than or equal to B, greater than or equal to A and less than B, greater than A and less than B, greater than or equal to A and less than or equal to B. Fixed comparison values can be customized, while dynamic field comparison values are system-selected.
    • Color Scheme: After setting the filter conditions, click the color button to customize the color.
    • Add Rule: Click + to add a filter condition.
    • Delete: Click - to delete a filter condition.
  • Icon
    • Condition selection: Choose between comparing with a fixed value or a dynamic value.
    • Icon Style: Choose from pre-selected icons or set a custom icon after the filter conditions.
    • Filter Condition Types: Includes greater than, greater than or equal to, equal to, less than or equal to, less than, not equal to, greater than A and less than or equal to B, greater than or equal to A and less than B, greater than A and less than B, greater than or equal to A and less than or equal to B. Fixed comparison values can be customized, while dynamic field comparison values are system-selected.
    • Add Rule: Click + to add a filter condition.
    • Delete: Click - to delete a filter condition.

Interactions

  • Link

    On the Interactions tab, choose Advanced > Link. In the Chart Linkage Configuration dialog box that appears, set parameters by referring to Table 8. For details, see Example linkage.

    • Filter
      1. Click Filter. The Filter tab is displayed.
      2. Click next to Fields to Bound. The associated field box is displayed.
      3. Click , select the field to be bound, select the associated chart, and click OK.
    • Shown/Hidden
      1. Click Show/Hidden. The Shown/Hidden tab is displayed.
      2. Select the associated chart and click OK.
      Table 8 Chart linkage configuration parameters

      Parameter

      Description

      Filter

      • Fields to Bound: Select the fields to be bound.
      • Associated Charts: Set linked associated charts. You can select charts from the same dataset or different datasets.

      Shown/Hidden

      Select the required fields first and then select the charts to be associated with them. You can select all charts on the large screen.

      • Click Show/Hidden. The Shown/Hidden tab is displayed.
      • Select the associated chart.
  • Redirect
    1. On the Interactions tab, click the edit icon next to Redirect under Advanced.
    2. In the Chart Redirect dialog box that appears, click next to Component to Be Bound.
    3. Set Redirect Type, Open Mode, Redirect to Reports/Screens, and Associated Parameters, and click OK. For details, see Redirect Example.
      • You can redirect with parameters. For specific examples, refer to Example of Redirection with Parameters.
      • To set up redirection, drag the desired fields to the Fields tab. Then, navigate to the chart redirection page to configure the bound fields. Failure to do so will result in unsuccessful redirection.
      Table 9 Parameters

      Parameter

      Description

      Redirect Type

      Intra-system redirect: Redirect to the internal screen and dashboard projects.

      External redirect: Redirect to a link that is not in the software.

      Open Mode

      Open in this window: After you click the chart with redirection set, the target chart is opened in the current window.

      Open in new window: After you click the chart with redirection set, the target chart is opened in a new window.

      Open in popup window: After you click the chart with redirection set, the target chart is opened as a pop-up window. The size of the pop-up window is customizable.

      Redirect to Reports/Screens

      1. Select a project first.
      2. Select a dashboard/screen.
        NOTE:

        This step is mandatory when Redirect Type is set to Intra-system redirect.

      Associated Parameters

      Set Effective Parameters of This Screen.

      • Associated Parameters: Carry associated fields to the chart that you are redirecting to.
      • Enter a fixed value: The chart that you redirect to only filters the fixed value. For example, if the fixed value is set to city, the chart that you redirect to displays the filtered city field.
      • Control Variables: Each value selected in the drop-down box, search, or tab list is a variable value set by the control variable. For example, if you select city in the drop-down box, the variable value of the control variable is city, and the chart that you redirect to filters out the city field.
      • Global Parameters: Carry the values in the global variables to the chart that you redirect to.

      Carry condition

      When Redirect Type is Intra-system redirect, null values can be carried. Carrying null values is mainly used for filtering null values in data tables, making it easier for users to analyze data.

      • Prerequisites: Set up two large screens, A and B, with screen A linking to screen B.
      • Procedure
        • Configure global parameters in screen B and ensure that the same fields exist in screen A.
        • Set the redirect parameters in screen A, select screen B as the target, and choose associated fields from the global parameters.
        • Select Carry null value and click OK.
        • The bound field in screen A will be underlined. Click it to redirect to screen B and filter out rows with null fields. The URL of screen B will display the param parameter.
        • Deselect Carry null value and click OK.
        • The bound field in screen A will be underlined. Click it to redirect to screen B and display all chart data. The URL of screen B will not display the param parameter.