Sorting

Version

Application Scenarios

You can use the Sort function to sort data.

Functions

Allow adding the Sort step in the data editing interface to sort data.

Click Sort on the top or choose  > Sort on the right to start sorting.

Click the header of a column to sort that column in the data editing interface.

Notes

• Direct data does not support sorting.

• Before enabling Chinese character sorting, all data was sorted according to the dictionary of UTF-8 encoded characters. In UTF-8, Chinese characters are sorted based on the order of the Kangxi Dictionary.

• After enabling Chinese character sorting, upon restarting the FineBI server and updating all data, all Chinese characters in the data are sorted based on their pinyin pronunciation.

Note:

This rule is also available on Table Sorting and Chart Sorting in the dashboard.

1. Choose My Analysis > New Subject to go to the Select Data page, and select a table.

This example uses Contract Fact Table.

2. Click Field Settings to select specific fields.

Adding the Sort Step

1. Add the Sort step.

2. Click Add a sorting sequence, select the Number field and the Descending order, and the data is sorted from largest to smallest according to Number.

3. Based on the sorted Number, you can add a sorting column Contract Volume. Finally, the Number column is sorted in descending order. When Number is the same, it is sorted in descending order according to Contract Volume.

Note:

The Sort function just assists you in calculations, and data can be sorted in the editing interface. However, when you preview data after saving the data table, the data may not be displayed in the order arranged.

Sorting Directly in the Table Header

Data is first sorted in descending order based on Contract Volume and then on Number.

You can set sorting in the drop-down menu of the header.