Multi-column Sorting

1. Overview

1.1 Expected effect

Multi-column sorting is to first sort column A as a whole according to condition 1, and then sort column B within the group on the premise that column A is sorted according to condition 2.

For example, in the product sales, it is necessary to sort the products according to the "Date" in ascending order, and if this sort is satisfied, the "Sales Volume" of the products sold every day within the "Date" should be sorted in descending order. Results as shown below:

1.2 Implementation ideas

1) First realize the overall sorting: set the "Date" in ascending order.

2) Realize the sorting within the group again: by arranging "Product" in descending order of "Sales Volume" to realize the descending order of "Sales Volume" of products.

2. Dashboard operation steps

Sample data: FRDemo_SALES_BASIC

2.1 Upload data

1) Add a table. Before making components, you need to prepare data and upload the data to the business package. Open "Data Preparation>package" and click "Add Table>Database Table" to add a table. As shown below:

2) After uploading the "FRDemo_SALES_BASIC" table, you can view and modify the "Field Type" and "Table Name" in the table. In this example, select the default value. Click "OK" to complete the data upload. As shown below:

2.2 Create components

After the data is uploaded successfully, click "FRDemo_SALES_BASIC> Data Preview" to view the data. Click "Create Component" to edit the dashboard information where the component is located, and click "OK" to complete the component creation. As shown below:

2.3 Add group table

After creating the component, jump to the component editing interface and add a group table. Select "Group Table" for the chart type, and drag the field with the analysis area into the dimension indicator column, as shown below:

2.4 Multi-column sorting

First realize the ascending sorting of "Date". Click ">Ascending" next to "Date" to complete the grouping table and sort it in ascending order of "Date". As shown below:

2) In descending order of the "Sales Volume" of each product. Click ">Descending>Sales Volume(Sum)" next to the "Product" field to achieve descending order within the sales volume group. As shown below:

After finishing the multi-column sorting, click "Enter Dashboard" to view the effect.

2.5 View the effect of dashboard

2.5.1 PC

For details of the dashboard effect, please refer to section 1.1 of this article.

The completed dashboard can be found in: Multi-column Sorting Dashboard.

2.5.2 Mobile

The mobile terminal display effect details, as shown in the following figure:

3. Implementation steps of self-service data set

Note: The self-service data set does not support mobile viewing.

3.1 Upload data

Same as section 2.1.

3.2 Create a self-service dataset

Create a new self-service dataset and select all the fields under "FRDemo_SALES_BASIC", as shown in the figure below:

Add the "Group Summary" step, drag the "Date" and "Product" into the "Group" column, and drag the "Sales Volume" into the "Summary" column, as shown in the following figure:

3.3 Sort "Date" in ascending order

Add the "Sort" step and click "Add a sorting column" to sort the "Date" in ascending order, as shown in the figure below:

3.4 Sort "Sales Volume" in descending order

Add the "New column" step. After naming, set the value rule to "within the group descending ranking", select the field "Sales Volume", and set the grouping method as "Date", click "OK", as shown in the following figure:

Name and save the self-service data set.

3.5 View the effect of self-service dataset

You can see the sorted data in the data preparation interface, as shown in the figure below: