Cross Table

Язык статьи: Английский

A cross table displays summary values of a field in a table and merges similar data. One group of columns is displayed on the left side of the table, while the other group is displayed at the top. The intersection of rows and columns can be used to calculate summary values by adding them up. This section will show you how to add data and configure styles for a cross table.

Notes and Constraints

Row headers generate left-side rows and allow for dimensions and metrics.
Column headers generate top-side columns and allow for dimensions and metrics.
Summary values generate the middle part of the cross table and allow for dimensions and metrics.

Prerequisites

A project has been created by referring to Creating a Project.
A data source has been connected by referring to Creating a Data Source.
A dataset has been created by referring to Creating a Dataset.
A dashboard has been created by referring to Creating a Dashboard.

Procedure

In the top navigation bar on the dashboard creation page, click to create a cross table.
Select a dataset in the Data area.
Set parameters on the Field, Style, and Advanced tabs.
Click Update. The system automatically updates the chart.
Figure 1 Cross table chart
Click Save or Save and Publish in the upper right corner to save the cross table.
Note
Click Save in the upper right corner. In the displayed dialog box, enter the dashboard name, and click Confirm. The saved dashboard cannot be viewed but can be deleted.

Click Save and Publish to save and publish the dashboard. You can view the saved dashboard. To delete the dashboard, you need to take it offline first.
On the displayed dashboard page, enter a dashboard name. Click OK.

Field

Table 1 Table style parameters
Parameter	Description
Cross Table Rows	Used to generate left-side rows and allow for dimensions and metrics.
Column-Store Table Header	Used to generate top-side columns and allow for dimensions and metrics.
Summary	Used to generate the middle part of the cross table and allow for dimensions and metrics.
Filter	Filter Settings: Click next to the field you wish to filter and you will be directed to the filter settings page. Filter Mode: When the field to be set is a dimension, it supports filtering by condition and filtering by enumeration. Filter Form: When the field to be set is a dimension, under the filtering by condition method, it supports setting AND conditions and OR conditions. Under the filtering by enumeration method, it supports single selection and multiple selection. Filter Criteria: When the field to be set is a dimension, filtering by condition supports settings such as exact match, contains, starts with, ends with, not match, not contain, is empty, is not empty, etc. When the field to be set is a dimension, filtering by enumeration method requires selecting the corresponding field. When the field to be set is a metric, filtering conditions support settings such as >, ≥, <, ≤, =, ≠, is empty, is not empty, etc. It also supports settings before and after data aggregation. Condition Form: When the field to be set is a metric, it supports setting AND conditions and OR conditions. It also supports settings before and after data aggregation.
Sorting	Sorts the dragged class axis/dimension fields in ascending or descending order. Sorting settings: Click of the sorting field and choose the desired order. NOTE: 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.
Maximum Query Results	The value ranges from 1 to 10000.
Auto Refresh	Auto-refresh: Set the time for data refresh, which can be 1 minute, 5 minutes, 15 minutes, 30 minutes, or no refresh.
Update	Click Update to automatically update the chart.

Style

Set cross table style parameters based on the table below.

Table 2 Basic Settings
Parameter	Description
Card Title	Cards can be configured with or without a title. If a title is set, it will be displayed in the top left corner of the card. If the checkbox is not selected (), the card will have no title. If the checkbox is selected (), the card will have a title.
Text	You can adjust the font size and color of the text. To change the font size, you can either type in the desired size or use the and buttons. NOTE: Note that the input cannot be empty and must be from 14 to 32.
Alignment	You can align the text in the card to the left or center.
Bottom Margin	Set the distance between the cross table title and the chart. To change the margin, you can either type in the desired margin or use the and buttons. NOTE: Note that the input cannot be empty and must be from 0 to 32.
Divider	Cards can be configured with or without a divider line. If the checkbox is not selected (), the card will have no divider line. If the checkbox is selected (), the card will have a divider line. You can customize the style and bottom margin of the divider line. The style and bottom margin can be set by inputting values or using the and buttons. NOTE: Note that the input for the style cannot be empty and must be from 0 to 8. The bottom margin can only be set after the style has been set, and the input cannot be empty and must be from 0 to 32.
Card Background	Cards can be configured with or without a background. If the checkbox is not selected (), the card will have no background. If the checkbox is selected (), the card will have a background. The background color can be set.
Status Icon	You can customize the display style and color of the icon, which can be set to always show or show on hover. The card icon can be set to have a status or no status. If the checkbox is not selected (), the icon will have no status. If the checkbox is selected (), the icon will have a status.
Visualization Style	There are three display modes available: tiled display, tree display, and custom tree display.
Pagination	You can set the number of data pages displayed in the cross table, and this can be done within the chart itself. The supported options for the number of pages are: 10, 20, and 50.
Value Settings	You can set the context, units, scientific notation, use of thousand separators, and decimal places for numerical values.
Table Header	The table header includes Column Summary and Row Summary. Column Summary Display Mode: right and left. Column Total and Column Subtotal: When the checkbox is selected (), you can customize their names. Row Summary Display Mode: bottom and top. Column Total and Column Subtotal: When the checkbox is selected (), you can customize their names. Indicator Display Grouping: Once enabled, the indicator sorting is based on the order of the indicators within the indicator group.
Series Settings	You can set the metrics. Context: Set the context for the series, supporting Simplified Chinese and English. Units: Units support automatic, none, hundred, thousand, ten thousand, hundred million, ten billion, and trillion. Scientific notation: Supports the use of scientific notation. Use thousand separators: Supports the use of thousand separators. Decimal places: Supports setting decimal places, with a range of 0 to 10.

Advanced

Linkage

Click the Advanced tab and click next to Linkage. The Chart Linkage Settings page is displayed. Set parameters. For details, see Linkage example.

Table 3 Chart linkage configurations
Parameter	Description
Filter	Select the fields to be bound first and then select the chart to be associated with them. You can select all charts on the dashboard.
Associated Charts	Link the associated charts. Follow bound field: When the bound field is set to A, the associated data tables filter data related to A. SQL placeholder: The bound field value corresponds to the value set for the SQL placeholder in the dataset.

Redirect

Choose Advanced > Redirect. The Chart Redirect page is displayed. Set parameters.

Select the fields to be bound and click OK.

Table 4 Chart redirect parameters
Parameter	Description
Redirect Type	Redirection type. You can choose to redirect internally within the system or externally through a link.
Open Mode	You can choose to open it in the current window, a new window, or a popup window.
Redirect to Reports/Screens	You can select the project, dashboard, or large screen you want to redirect to. NOTE: When Redirect Type is set to Intra-system redirect, Redirect to Reports/Screens can be selected.
URL	Enter the URL when you choose to redirect externally through a link. NOTE: When filling out a URL, you need to ensure its security. If the URL is insecure, it may pose a security risk to your data. Be cautious when filling out the URL.
Associated Parameters	Parameters that take effect in the current report can be selected as associated fields or fixed values. Global parameters for Redirect to Reports/Screens can be selected only after global parameters are set.
Carry Condition	When Redirect Type is Intra-system redirect, multiple rows of fields and empty values can be carried (only can be set for table and dashboard). When Redirect Type is External link, empty 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 dashboards, A and B, with dashboard A linking to dashboard B. Procedure Configure global parameters in dashboard B and ensure that the same fields exist in dashboard A. Set the redirect parameters in dashboard A, select dashboard B as the target, and choose associated fields from the global variables. Select Carry null value and click OK. The bound field in dashboard A will be underlined. Click it to redirect to dashboard B and filter out rows with null fields. The URL of dashboard B will display the param parameter. Deselect Carry null value and click OK. The bound field in dashboard A will be underlined. Click it to redirect to dashboard B and display all chart data. The URL of dashboard B will not display the param parameter. NOTE: If this option is selected and the chart allows for multiple data selections, the parameter carried will be an array containing the selected data.

Initialize Query for Associated Query Control: whether the associated query control supports query initialization. If the checkbox is selected (), the control supports query initialization. If the checkbox is not selected (), the control does not support query initialization.
Note
If you select this option, when a chart is linked to a query control and the query control does not have a default query set, the chart's data configuration will be queried during chart initialization.

Parent topic: Table

Эта статья полезна?

Поддержка Юридические документы