Tables are one of the most common visualization components and an important carrier for displaying summary and detailed data. Table applications are divided into ordinary tables and pivot tables.A common table consists of a combination of multiple dimensions and multiple indicators, which is relatively simple.Pivot table is a complex combination of row dimension, Levi dimension and indicator.Here's a detailed description:
common form
A common table is a simple tabular form consisting of rows and columns, usually presenting data in the form of numbers or text. Each column represents a specific attribute, each row represents a record, and data processing is based on the column.
Data configuration
- Data configuration area:Configure the summary mode of field dimensions/indicators in the field resolution area
- Field Settings area: Click a field on the axis to invoke the field Settings drop-down
- Can change how the indicators are aggregated (sum, average, count, maximum, minimum, median, standard difference, etc.)
- Advanced calculation (proportion, sequential)
- You can set the data display format of the field
Style configuration
The table style configuration is used to change the look and feel of the table visualization component. You can create a unique table style by configuring different styles of the table
Title editor
Edit the title of each visual component
Time range display
Check whether to display the time range of the current chart data under the Visual component heading
Total
The sum of a common table refers to "Sum, average, count, maximum and minimum "and other summary calculations for multiple columns of metrics in the table.If you select "Show Sum", a new line will be added to the table to calculate the sum value of each metric column. After selecting Custom, you can perform custom calculations based on different indicators (different columns). For example, now select "Show sum", select "maximum value" for the first column indicator, and select "sum" for the second column indicator, as shown in the following figure:
Indicator style
Indicator Style setting Sets the style of a single or multiple columns of indicators in a table. This parameter applies only to common tables. The indicator style can be displayed in digital display, color level display, and data bar display. The single-column hotspot distribution means that different indicator columns independently control the value size to display the color level or data bar. The global hotspot distribution means that all selected indicator columns display the color level or data bar according to the value indicator size.
For example, select hotspot distribution in a single column for the table, and select different styles for different indicators (different columns). Select data bar for indicator 1, and color level for indicator 2. The configuration process is as follows:
Number
Adds a new column to the table to display the serial number column
Paginator
Set the number of rows displayed on each table page. The default value is 10. You can select 30, 50, 100, or 200 rows
Column width setting
You can adjust the width of each column in batches or set the absolute value in a single column based on the actual table.
- Under the "default" policy, column widths are saved proportionally and stretched adaptively based on the screen width currently in use
- In Custom configuration, column widths are saved by value. Ignore the current screen width and column width, and the screen width and column width remain the same.
Pivot Table
Pivot table is an interactive table that can quickly summarize and calculate data through multidimensional analysis and filtering of data. A pivot table generally includes four areas: rows, columns, values, and filters. Users can drag and drop the data fields they need to analyze into different areas to achieve multidimensional data analysis.
Data Configuration
Data configuration is used to populate the data content within the table framework and create complex pivot tables based on different row dimensions, column dimensions, and metrics.
Pivot tables display the cross-tabulated statistics of indicators based on row dimensions and column dimensions. Multiple row dimensions can be selected to display on the left side of the table, and multiple column dimensions can be selected to display on the top of the table. The corresponding metrics of the data are displayed at the intersection of row and column dimensions.
- Data configuration area: Configuring the field interpretation area for field dimensions/metric aggregation modes.
- Field configuration area: Click on the field on the axis to activate the field configuration drop-down.
- Change the aggregation method of the metric (sum, average, count, maximum, minimum, median, standard deviation, etc.)
- Perform advanced calculations (proportions, year-on-year, quarter-on-quarter, etc.)
- Set the data display format for the field
Style Configuration
Table style configuration is used to change the appearance style of the table visualization component. By selecting different style configurations for the table, a unique table style can be created.
Title Editing
Edit the title of each visualization component
Time Range Display
Check whether to display the time range of the current chart data below the title of the visualization component
Sum
Pivot table is an interactive table that allows for quick summarization and calculation of data through multidimensional analysis and filtering. A pivot table generally includes four areas: rows, columns, values, and filters. Users can drag and drop data fields to different areas to achieve multidimensional data analysis.
Metric Style
Metric style is used to set the style for single or multiple metric columns in a table. It is only applicable to normal tables. Metric style can be displayed as numeric, color scale, or data bar. In single column hotspot distribution, each metric column controls the value size and displays color scale or data bar separately. In global hotspot distribution, all selected metric columns are displayed together according to the value size and show color scale or data bar. For example, to select global hotspot distribution and configure it as color scale, follow the steps below:
Column Width Setting
You can adjust the width of each column in bulk based on the actual content of the table, or configure an absolute value for each individual column.
- Under the "Default" strategy, column widths are saved proportionally and automatically adjusted based on the current screen width.
- Under the "Custom" configuration, column widths are saved as specific values, ignoring the current screen width, and the widths of columns will remain consistent.