Highlight Duplicate Values in a Specific Column of the Grid Widget
This document will guide you in highlighting duplicate values within a specific column in the Bold BI Grid widget. Currently, Bold BI does not offer a direct feature similar to Excel's "Highlight duplicates" function. However, you can achieve this functionality in Bold BI by using expressions combined with conditional formatting.
Follow the steps below to achieve this:
- Create an Expression
- Define an expression to identify duplicate values in a specific column.
- Expression Syntax:
IF(COUNT([Column_Name]) > 1, 'Duplicate', 'Unique') - Replace
[Column_Name]with the actual name of the column you want to monitor. - This expression checks if the count of values in the column exceeds one, marking it as
'Duplicate'otherwise,'Unique'.
- Add and configure a grid widget
- Insert a Grid widget into your dashboard.
- Bind the specific column you want to monitor for duplicates.
- Bind the expression field under the Hidden Columns section of the grid.
- Apply conditional formatting
- Open the Properties panel of the Grid widget.
Navigate to the Formatting category.
Apply conditional formatting to the target column based on the values in the expression; specifically, highlight the rows where the result of the expression is "Duplicate."
- Save the configuration
- Save both the conditional formatting and the widget settings to apply the changes.
After these steps, your Grid widget will automatically highlight all duplicate values in the specified column.
Example
For instance, we have a column named "ShipCountry" containing duplicate values.
First, create an expression to detect duplicates in the "ShipCountry" column.
Condition:
IF(COUNT([ShipCountry]) > 1, 'Duplicate', 'Unique')Then, bind this expression as a hidden field within your Grid widget.
Finally, apply conditional formatting based on the expression's output.
Once configured, your Grid widget will visually highlight all duplicate " ShipCountry" entries.
