Marking the Inconsistent Data in a Table

Version

Expected Effect

You want to set the inconsistent data in three fields in a table to be displayed in red.

For example, the inconsistent data in the three fields corresponding to Fruit, Soda drink, and Banana are marked in red, as shown in the following figure.

Implementation Method

1. You can set a judgment value:

The judgment value is 0 if data values in the three fields are consistent.

The judgment value is 1 if data values in the three fields are inconsistent.

2. You can mark in red the data with the judgment value being 1 (namely the data with inconsistent values in the three fields).

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: Marker Judgment.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 Type field in the to-be-analyzed area into Dimension and Data One, Data Two, and Data Three into Indicator, as shown in the following figure.

Calculation Indicator Adding

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

2. Set Field Name to Judging if Values in the Three Fields are Consistent.

3. Enter the formula: IF(Data=Data Two,IF(Data Two=Data Three,0,1),1).

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 calculation indicator, as shown in the following figure.

Text Color Setting

1. Drag the Judging if the Three Values are Consistent field in the left to-be-analyzed area into Color under Table Property > Indicator > All.

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

3. Set values in the Data, Data Two, and Data Three fields to be displayed in red if the values in the Judging if the Three Values are Consistent field are greater than or equal to 1.

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

Effect Display

PC

Mobile Terminal