A table is both a visual communication method and a means of organizing and structuring data. It consists of one or more rows of cells and is used to display numbers and other items for quick reference and analysis. This article introduces the specific features of tables in visual charts.

Users can display the corresponding detailed data by simply configuring dimensions and metrics. At the same time, tables also support chart configuration, field configuration, column operations, and more.

Tables are typically used in scenarios where users focus more on detailed data or need to display multiple directly related values.
For example: Within a specific time period, what products did the regional manager sell, and what was the profit.

1. Set Set dimension and metric conditions and Configure the Filter. Select "Province" and "Transaction Date" as dimensions, and select 'order_count' and 'price' as metrics; filter the date as "Last 1 day with data".
   

   tip

   p_date is the partition date field of the dataset. It is supported in extraction mode, but not available in direct connection mode.
   p_date represents the date when data is synchronized to the product dataset (if the upstream data does not have a date partition), or the date when data is generated in the upstream data table (the original Hive table's date/p_date partition fields are renamed to p_date).
   In visual queries, you can select and filter by date dimension according to analysis requirements. By default, the most recent day with data is selected.

2. Select Chart Panel - Table. Table is selected by default.
   
3. Modify the chart style in the chart configuration area as needed.
   

Dimensions: Supports zero or more dimensions.
Metrics: Supports zero or more metrics.
Combination rules: One or more dimensions with zero or more metrics; zero or more dimensions with one or more metrics.
Example: One dimension, three metrics.

Basic format #

Supports configuration for serial numbers, automatic line wrapping, row and column transposition, metrics first, dimension cell merging, and more.

Pager #

When there are many data entries, you can configure a pager for the table. The pager supports a minimum of 10 items per page and a maximum of 100 items per page. After setting the pager, in V2.91.0 and later versions, the table supports displaying 1k, 2k, 5k, 10k, 20k, 30k, 40k, and 50k data entries, or you can manually enter a positive integer (up to 50k) for the number of entries.

Text alignment #

You can set the text alignment for dimensions and metrics separately. Currently, left, center, and right alignment options are available.

Table style #

• You can modify the table style and switch between minimalist and standard styles.
  
• The row headers can be shown or hidden.
  
• You can configure the colors of the table headers, cell text, and gridlines.
  

Gridlines #

You can adjust the color, line width, and line style for the table's outer border, horizontal gridlines, and vertical gridlines.

Sparklines #

From version V2.44 and later, tables support inserting Sparklines. For details, see Sparkline.

Special values #

You can customize the display of special values for dimensions or metrics, and set the style for special values to appear as blank, NULL, 0, or --.

Custom fields #

After enabling this option, the chart will support the custom fields feature in the dashboard.

Display mode #

The display mode can be customized so that the table's appearance can be adjusted as needed, including:

• Column width: Fit to content, fit to container, or custom.
• Row spacing/column spacing: Comfortable (default spacing, 8 pixels), efficient (narrower, 4 pixels), or custom.

In-chart control style #

In-chart controls include in-chart filters, dynamic dimensions/metrics, and in-chart parameters. After displaying them in the chart, you can adjust the arrangement of the title and filter content, as well as the layout settings. The following figure shows dynamic dimensions arranged vertically.

Restore default settings #

Click Restore Default Settings to revert all the above chart configurations to their default values.

Parse text #

Please refer to Text parsing.

Conditional formatting #

Please refer to Set conditional format.

Edit visual style #

Please refer to Visual style.

Configure metric groups #

Tables support the metric group configuration feature, allowing you to view metrics by category.

1. In the visual query interface, click the metrics button to display a drop-down menu, then click "Configure Metric Groups".
   
2. In the pop-up page, click "Create Group" and then name the group.
   
3. Then, drag the metrics you want to include in this group into the group using the mouse.
   
4. Click OK to save, and you can then view these metrics by category.
   

Adjust column width #

Drag the divider between two columns in the table with the mouse to adjust the column width.

Column sorting #

When you hover the mouse over the column name in the table header, the column sorting button will appear. Click the button to sort the column contents, and click again to cancel sorting.

Freeze columns #

When there are many columns, you can freeze a column you want to keep visible. When you scroll left or right to view other columns, the frozen column and all columns to its left remain stationary. Click the dropdown list in the corresponding column header, select Freeze column, and click again to unfreeze the column.