Marking the Above-Average Data in a Table

Version

Expected Effect

You can mark the above-average data in a table.

For example, mark the above-average data in Contract Amount in red with a red smiley face, as shown in the following figure.

Implementation Method

1. Calculate the average of the contract amount.

2. Set a judgment value:

If the value of the contract amount exceeds the average, the judgment value is 1.

Otherwise, the judgment value is 0.

3. Mark the contract amount whose judgment value is 1 in red with a smiley face.

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.

2. Select Group Table in Chart Type.

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

Average Calculation Field Adding

1. Click the ... icon and select Add Calculation Indicator from the drop-down list.

2. Name the field as Average.

3. Enter the Average calculation formula: TOTAL(SUM_AGG(Contract Amount))/TOTAL(COUNTD_AGG(City)).

Note:

Functions and fields in the formula need to be selected from the left area and cannot be entered manually.

The following table describes the formula.

4. Click OK to add the Average field, as shown in the following figure.

Judgment Calculation Field Adding

1. Click the ... icon and select Add Calculation Indicator from the drop-down list.

2. Name the field as Judgement.

3. Enter the Judgment calculation formula: IF(SUM_AGG(Contract Amount)>Average,1,0).

The following table describes the formula.

4. Click OK to add the Judgment field, as shown in the following figure.

Table Color and Shape Setting

1. Drag the Judgement field in the to-be-analyzed area into Color under Table Property > Indicator.

2. Click Color and click the Add Condition button in the pop-up settings box.

3. When you set the Judgment value above 1, the Contract Amount indicator is displayed in red, as shown in the following figure.

4. Drag the Judgement field in the to-be-analyzed area into Shape under Table Property > Indicator.

5. Click Shape and click the Add Condition button in the pop-up settings box.

6. When you set the Judgment value above 1, the Contract Amount indicator is marked with a red smiley face.

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 the Above-Average Data in a Table, and click OK.

Effect Display

On PC

On Mobile Terminals