Table Sorting

Application Scenarios

When you are creating table components, you may hope that the data can be displayed in a certain order based on the filtered results of the filtering component.

Functions

There are two ways to sort the table: by dimension fields of the analysis area and by the table header of the chart generation area.

Note: Detail table only supports sorting by the table header.

Exclusion

Note: Detail table cannot be sorted by dimension fields.

Ascending/Descending Sorting

You can designate fields as sorting rules in Dimensions.

Fields that can be set as sorting rules are as follows:

1. Sorting According to the Field Itself

The dimension field will sort itself automatically If the first character is identical, the subsequent character will be compared to determine the sort order. For example, sort the Contract Signing Time field in descending order based on itself.

The Contract Signing Time will be sorted in descending order based on the latest date.

Note: The default sorting rule is UTF-8.

2. Sorting According to Other Fields

a. Sort according to fields in Indicator

For example, sort the Contract Type in ascending order based on Purchase Quantity field.

b. Sort according to other fields in Dimensions

• If other fields have a one-to-one correspondence with the field to be sorted, the field will be sorted accordingly. For example, sort the Contract ID field in ascending order based on Contract Signing Time.

• If other fields correspond to multiple values, it will be sorted in ascending/descending order based on the smallest/largest field value in the group.

For example, sort Contract Type in ascending order based on Contract Signing Time. Then Contract Type will be sorted in ascending order based on the value of Contract Signing Time.

Custom Sorting

You can customize the  order by dragging and dropping.

For example, to set custom sorting for contract types, click Custom Sort as follows:

Drag and drop field to set custom sorting and click OK to save.

The sorting icon will not be displayed in the header if you select Custom Sort.

The following will introduce different sorting rules in the header through different table components.

Group Table

Note: Sorting rules set for fields in Indicators will override those set for fields in Dimensions. Because of the grouping logic of the group table and cross table, it will first be sorted by summary values and then sorted within the group.

How to sort field values in the header in the group table:

For example, set the Contract Type to sort by ascending order and the Contract Signing Time to sort by ascending order within the group.

Note: The default sorting rule is UTF-8.

Sort Purchase Quantity in descending order. Because of the grouping logic of the group table and the cross table, field values will be sorted according to the summary value first and then sorted within the group.

To be specific, sort the total purchase quantity of different contract types in descending order. Then sort the purchase quantity corresponding to the Contract Signing Time in each contract type in descending order within the group.

Cross Table

Dimensions: supports Ascending and Descending order.

Indicators: supports Ascending, Descending, and Not Sorting. The sorting rules set in fields of Indicators will override those set in the Dimensions. Because of the grouping logic of the group table and cross table, it will first be sorted by summary values and then sorted within the group.

The header sorting of the cross table is basically the same as the header sorting of the grouped table. You can see section "Group Table" in this article.

Note: When there are identical fields in the row and column dimensions, sorting one field will also synchronize the sorting for the other. For example, if both contract types are present in a cross table, sorting any contract type will also synchronize the sorting for the other contract type.

Detail Table

After the first field in the detail table has been sorted, the second and subsequent fields will be sorted within the group based on the sorting of the first field.

Note: Calculation fields cannot be sorted.

For example, sort the contract type, contract signing time, and contract amount in descending order. Then the Contract Amount will be sorted in descending order within the group after the first two descending sorting rules have been met.

Sorting Empty Value

Empty value is the minimum value. It will be sorted at the front in ascending order and at the end in descending order. .

Using Custom Sorting and Filter Components Together

When utilizing the filter component and custom sorting in the table, all data (not just the filtered results) will be presented during sorting.