Chart Sorting

Version

Application Scenarios

You may hope that data can be displayed in a certain order based on the filtered results of the filtering component when creating table components.

Functions

The sorting of charts supports setting the sorting of dimension fields in Horizontal Axis, Vertical Axis, and Graphic Properties.

There are three types of sorts: Ascending, Descending, and Custom Sort. Custom Sort allows adjusting the order of field values as needed.

Note:

The date field only supports Ascending and Descending. The indicator field does not support sort, while the dimension field supports.

After clicking  of the dimension field in Horizontal Axis or Vertical Axis, you can see the Ascending and Descending settings.

The fields can be selected for ascending and descending are all the dimension fields and the dragged-in indicator fields in the current data table.

Sorting in Horizontal Axis

For example, if you sort by Contract Amount in ascending order, Registration Time on the horizontal axis of the chart is sorted in ascending order according to the value of Contract Amount.

Sorting in Vertical Axis

After the dimension field Payment Type in Vertical Axis is set to be sorted in descending order by Contract Amount, the chart shows that the vertical axis categories are sorted in descending order by Contract Amount.

You can sort the dimension field dragged into the Graphic Properties.

For example, drag Payment Type into Color, select Ascending according to Contract Amount, and the Payment Type field will be sorted in ascending order according to Contract Amount and be assigned to different colors.

Using Custom Sort and Filter Component Together

If you first use Filter Component and then Custom Sort in the chart, all data will be displayed when setting the sort.

Optimizing the Sorting Logic

Chart sorting logic is optimized in FineBI 5.1.12 and later versions.

The specific introduction is shown below:

• The self-sorting of the first dimension field on Vertical Axis is a global sort.

• The self-sorting of dimension fields in Graphic Properties (size, color, label) is a global sort.