Multi-Column Sorting

Functions

Multi-column sorting is to first sort column A overall according to condition 1, and then sort column B within the group based on condition 2 while satisfying condition 1 at the same time.

For example, in the product order details, you need to first sort Order Date in ascending order. Then, sort Product by Quantity within each order date in descending order (keep the first sorting state).

Implementation Method

1. Sort as a whole: Set Order Date to sort in ascending order.

2. Sort within the group: Sort Product in descending order by Quantity.

Sample data: Multi-Column Sorting—Product Order.xls

Creating a Subject

Create a subject and upload the downloaded sample data.

Adding a Component

After adding data, click the Add component button at the bottom.

Adding a Group Table

After clicking Add component, you can go to the component editing interface to add a group table.

Select Group Table as Chart Type and drag fields in the area for analysis into Dimensions and Indicators.

Multi-Column Sorting

1. Sort Order Date in ascending order first.

Choose  > Ascending to sort Order Date in ascending order.

2. Sort the ordered Quantity of each daily product in descending order.

Choose  > Descending > Quantity(Sum) beside the Product field to sort Product by Quantity within the group in descending order.

3. Add a dashboard and drag the component into the dashboard to view the effect.

Dashboard Effect Display

For details about the dashboard effect, see section "Functions" of this article.

Mobile display effect is shown below.

Note:

The dataset cannot be viewed on mobile devices.

Adding Data

Same as section "Creating a Subject".

Removing Duplicate Data

Add the Group Summary step.

Drag Order Date and Product into grouping, and Quantity into Total.

Sorting the Date Field in Ascending Order

Add the Sort step.

Click Add a sorting sequence to sort Order Date in Ascending order.

Sorting Product by Quantity in Descending Order

Continue to click Add a sorting sequence in the current step, and sort the Product by Quantity in Descending order.

Click Save And Update.

Demonstration

Click Exit and preview to see the effect.