Marking and Sorting the Top Three Data in a Table

Version

Expected Effect

You want to mark and sort the indicator values that meet certain conditions.

For example, you want the top three values (ranked in descending order) of the Refund Amount indicator to be attached with crowns in different colors and sort the values in descending order, as shown in the following figure.

Implementation Method

1. Firstly, you need to know the differences between ranking and sorting.

Ranking: It means arranging rankings in ascending/descending order.

Ascending order (ranking) means arranging rankings in ascending order based on increasing values, with smaller values corresponding to higher rankings.

Descending order (ranking) means arranging rankings in descending order based on decreasing values, with larger values corresponding to lower rankings.

Sorting: It means arranging the sorting in ascending/descending order.

Ascending order (sorting) means arranging the sorting in ascending order based on increasing values, with smaller values corresponding to higher orders.

Descending order (sorting) means arranging rankings in descending order based on decreasing values, with larger values corresponding to lower orders.

2. Then, you can rank the Refund Amount values in descending order, set the top three values to be attached with crowns in different colors, and arrange the sort in descending order.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject.

2. Click Local Excel and Upload Data.

You can download the sample data: Regional Data Analysis.xlsx.

3. Click OK after the data is uploaded.

4. Click Save and Update and Exit and Preview. The data is created successfully.

Component Creation

1. Click the Component tab in the lower left corner, as shown in the following figure.

2. Select Group Table in Chart Type.

3. Drag the Client field from the left to-be-analyzed area into Dimension and Refund Amount into Indicator, as shown in the following figure.

Text Color Setting

1. Drag the Refund Amount field from the left to-be-analyzed area into Shape under Table Property > Indicator.

2. Click the  button and choose Quick Calculation > Ranking > Descend from the drop-down list to arrange the values of the Refund Amount indicator in descending order to determine the ranking, where larger values correspond to higher rankings, as shown in the following figure.

3. Click Shape and click Add Condition in the pop-up setting box. Set the top three values of the Refund Amount indicator to be attached with crowns in different colors, as shown in the following figure.

4. Click the  icon next to the Refund Amount field in the table header and select Descend from the drop-down list to determine the sorting, where larger values correspond to higher rankings, as shown in the following figure.

Dashboard Creation

1. Click the Add Dashboard button at the bottom of the analysis subject editing page.

2. Drag the component into the dashboard on the Dashboard editing page.

3. Select Edit Title from the drop-down list, set Font Style to Custom, set the title to Marking and Sorting the Top Three Data in a Table, and click OK.

Effect Display

PC

Mobile Terminal