A raw-data table is a table that presents detailed data. Users can automatically correlate and display detailed data by clicking on the table and selecting the required fields.

2.1 Common usage scenarios #

It is usually used in scenarios where detailed raw data presentation is required.
Table example:

2.2 Example of use process #

Step 1: select Chart Panel - Raw-Data Table
Step 2: set the dimensions and metrics to be displayed, and set the filter conditions
Select dimensions: "sale_province", "sale_city", "order_date", "product_type", "sale_price"
Step 3: modify the chart format as needed

3.1 List icon #

3.2 Configuration rules #

Dimensions: Supports 0 or more dimensions.
Metrics: Supports 0 or more metrics.
Dimensions and metrics are displayed in the raw-data table in the order in the data panel. Metrics are not aggregated.

3.3 Chart configuration #

3.3.1 Basic format #

• Serial number: Add a serial number before each piece of data to quickly find a row of data when there are many data items.

• Transpose: The default data is displayed horizontally. After checking "transpose", the data is displayed vertically.
• Note: Data items within 100 can be transposed. If there are more than 100 items, it cannot be configured.

• Word wrap: When the text exceeds the width of the table, the text is omitted by default. If you want to display more or all of the text, lengthen the table width or set automatic line wrapping.

3.3.2 Pagination #

When there are many data entries, you can configure pagination on the table. Pagination supports a minimum of 10 pages per page, and a maximum of 100 pages per page. V2.91.0 and above, after setting pagination, the table supports displaying 1k, 2k, 5k, 1w, 2w, 3w, 4w, 5w pieces of data, or manually entering positive integer (upper limit is 5w) data.

3.3.3 Text alignment #

Support setting text alignment for dimensions and metrics separately. Currently, there are three alignment methods for left, center, and right.
After enabling advanced configuration, you can set the alignment of the table header and body content respectively:

• Dimension table header: Default left, support left, center, right.
• Dimension table body: Default left, support left, center, right.
• Metric table header: Default right, support left, center, right.
• Metric table body: Default right, support left, center, right.
• Serial Number: After checking "Serial Number" in "Basic Format", it appears, and the default is left. The title of the serial number and the content of the serial number are uniformly set to be left, centered, and right.

Advanced configuration is turned off by default, and the original dimensions and metrics are still configured uniformly when closed.

3.3.4 Table style #

Color configuration for texts of headers and tables, and gridlines color.

3.3.5 Grid line #

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

3.3.6 Special value #

You can customize settings for dimension/metric special values. If a field originates from a dimension, it will be processed according to the dimension, and if it originates from a metric, it will be processed according to the metric. Special values can be set to be displayed as blank/NULL/0/--.

Note: When the analytical text of the raw-data table is a picture, if the picture can be displayed, the corresponding picture will be displayed in the raw-data table; if the picture cannot be displayed, the table will be displayed empty.

3.3.7 Display mode #

The display mode can be customized to allow the table display effect to be adjusted according to the actual situation, including:

• Column width: adapt to content, adapt to containers, customize;
• Line spacing/column spacing: relaxed (default spacing, 8 pixels), compact (narrow, 4 pixels), custom;
• Table row spacing: relaxed, compact, and customizable.
• Header line spacing: relaxed, compact, custom;
• Frozen area width: When there is a frozen area in the table, it supports setting the frozen area width in pixels. Default(the sum of the column widths in the frozen range has been selected), Customization: After selection, the text box is provided to support px-level configuration, and the maximum input value is limited to the sum of the column widths of the frozen area.

Manually set the column width, the equal width of each column is the set width, in pixels

3.3.8 In-diagram control styles #

The in-image controls include in-image filters, dynamic dimensions/metrics, and in-image parameters. After being displayed in the image, you can adjust the title and filter content placement, as well as the layout settings. The picture below shows the dynamic dimension arranged up and down.

3.3.9 Restore default settings #

Click Restore Default Settings, and the content in the above chart configuration will be restored to default.

3.4 Field configuration #

3.4.1 Text parsing #

3.4.2 Set conditional format #

3.4.3 Visual style #

3.5 Forms #

3.5.1 Adjust column width #

Drag the dividing line between the two columns of the table with the mouse to adjust the column width of the table.

3.5.2 Column sorting #

Hover the mouse in front of the column name in the header, and the column sorting button will be displayed. Click the button to sort the column contents, and click again to cancel the sorting.
Note: If "Top N" is used in the analysis, the "Top N" operation takes precedence over the column ordering of the table.

3.5.3 Freeze column #

When there are many columns, the column of interest can be fixed in position. That is, when swiping left and right to view the contents of other columns, the fixed column and the columns to the left of the fixed column will remain stationary.

3.6 Chart switching #

3.6.1 Switch from table to raw-data table #

• Put the fields of dimensions and metrics into columns in the order of dimensions and metrics.
• Metric result filters in filters will be lost; detail filters and dimension filters for metrics will be retained.
• The configuration of the analysis panel will be cleared.
  Before switching: table
  
  After switching: raw-data table
  

3.6.2 Switch from raw-data table to table #

• Put the fields in the column into the dimensions or metrics of the table according to the dimensions or metrics, and the metrics are given the default aggregation method.
• Direct restore of filtered content.
• The configuration of the analysis panel will be cleared.
  Before switching: raw-data table
  
  After switching: table