Overview
Expected Effect
When designing a report, you may need to check whether duplicate values exist in the same column. If so, these values need to be highlighted, as shown in the following figure.
Implementation Method
You can use the Conditional Summary function to judge whether the number of occurrences of each cell value in this column is greater than 1.
You can add the Background attributes in Condition Attribute to set the highlighted background color.
Example
Data Preparation
Create a general report, and create a built-in dataset named Embedded1, as shown in the following figure.
Report Design
1. Design the table as shown in the following figure.
2. Select cell A2, choose Cell Element > Basic on the right attribute panel, and select List from the drop-down list of Data Setting to prevent the same data (if any) in the first column from being grouped and merged.
Condition Attribute Adding
Select cell B2, select Condition Attribute on the right attribute panel, add a Background attribute, set Formula Condition to Formula, and enter the formula: count(B2[!0]{B2 = $B2}) > 1.
The following table describes the formula.
| Formula | Description |
|---|---|
B2[!0] | All the values expanded from cell B2. |
{B2=$B2} | The corresponding expanded values from cell B2 as filter conditions. |
count()>1 | The value of the current cell is the condition to count the occurrence number of each value expanded from cell B2, and a count result greater than 1 indicates duplicate data. |
The following figure shows the steps.
Effect Display
PC
Save the template and click Pagination Preview. The effect is the same as that shown in section "Expected Effect."
Mobile Terminal
The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.
Template Download
For details, you can download the templates Highlighting Duplicate Values in a Column.cpt.
Previous：Background Color Setting Every Other Row/Column
