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.
You can use the Ranking and Group Ranking functions in Quick Calculation for a component.
You can use the Store sales statistics dataset in Public Data.
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.
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.
Use the formula RANK_ANLS(SUM_AGG(Sale Volume),0,"desc"). For the usage of the RANK_ANLS function, see RANK_ANLS.
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.
Choose Quick Calculation > Group Ranking > Descend in the drop-down list of the Sales Volume field, as shown in the following figure.
Use the formula RANK_ANLS(SUM_AGG(Sale Volume),1,"desc"). For the usage of the RANK_ANLS function, see RANK_ANLS.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy