Quick Calculation - Ranking

Application Scenario 

Rank the data in chart or table components.

For example, you may need to rank the regions and areas according to the proportion of the regional sales volume to the total sales volume, as shown in the following figure.

Function Description 

You can use the Ranking and Group Ranking functions in Quick Calculation for a component.

Note:

This function cannot be used in detail tables.

You can use the Store sales statistics dataset in Public Data.

Concept 

Ranking is to rank the currently grouped indicator according to the numerical size. You can sort the data in an ascending (from small to large) or descending order (from large to small).

For example, you can display the sales volume ranking of each region in a descending order, where the sales volume ranking of each area among all areas is also displayed in a descending order after all region nodes are expanded, as shown in the following figure.

Ranking 

Use the Store sales statistics dataset to create a group table, as shown in the following figure.

Drag the Sales Volume field into the Indicator bar again, and choose Quick Calculation > Ranking > Descend in the drop-down list of the Sales Volume field, as shown in the following figure.

Ranking Using Functions 

Use the formula RANK_ANLS(SUM_AGG(Sale Volume),0,"desc"). For the usage of the RANK_ANLS function, see RANK_ANLS.

Concept 

Group Ranking is to rank the indicator value in the current group. You can also sort the data in an ascending or descending order.

For example, you can display the sales volume ranking of each region in a descending order, where the sales volume ranking of each area in the region is also displayed in a descending order after all region nodes are expanded, as shown in the following figure.

Group Ranking 

Use the Store sales statistics dataset to create a group table, as shown in the following figure.

Choose Quick Calculation > Group Ranking > Descend in the drop-down list of the Sales Volume field, as shown in the following figure.

Group Ranking Using Functions 

Use the formula RANK_ANLS(SUM_AGG(Sale Volume),1,"desc"). For the usage of the RANK_ANLS function, see RANK_ANLS.