Sort data by field or stacked sum in Quick BI - Quick BI

Quick BI supports sorting by field and by stacked sum. Field sorting arranges data by a single field's values. When sorting by stacked sum, Quick BI first sorts data by field within each group and then sorts by the group total.

Prerequisites

You have created a dashboard.
You have selected a dataset and created a chart.

Sorting methods

Sort fields and by stacked sum:

Field Sorting: Sorts data by values in a specific field.

For example, setting order_number to Ascending sorts order_numbers in the Chart Data in ascending order:
Sort by stacked sum: Sorts data by the sum of stacked values.

Figure 1 shows order_number sorted in ascending order — the order_number in the chart data is still sorted from small to large. Figure 2 shows the result after applying stacked sum sorting — the stacked column chart is re-sorted by the stacked column sum.

Note
Stacked Sum sorting applies only to stacked column charts and stacked bar charts.

Field sorting

Go to the dashboard edit page. For more information, see Create a dashboard.
In the Chart Design section, click the Fields tab. Hover over the target field and click the icon.
Select Sort from the drop-down list.

Options:
- Ascend
- Descend
- Unsort: Clears field sorting.
- Custom: Drag and drop fields to arrange them in a custom order.
  
  Note
  Only dimension fields support custom sorting.
Click Update.

Note

Sorting priority: dimension fields first, then measure fields, then color legends.
When multiple measures have sorting applied, they are prioritized from top to bottom as listed in the data panel.

Sort by stacked sum

Sort by field arranges data by a single field's values. To sort by the total of each stacked group, use stacked sum sorting.

Stacked sum sorting is available only for stacked column charts and stacked bar charts.

Go to the dashboard edit page. For more information, see Create a dashboard.

Select the target chart and choose a sorting method as shown below.

Sorting Order	Description	Procedure
regular Sort	With regular Sort, results are sorted by a single dimension or measure field. Note Select regular sort to sort by field only.
Ascending by Stacked Sum	Sorts by stacked sum first, then by field. Field sorting order does not affect stacked sum order.
Sort by Stacked Sum in descending order

Click Update.