Skip to main content

Highlighting

Professional

The Highlighting feature in Brobench datagrids allows you to visually emphasize specific rows and cells with various colors to improve data analysis and visibility. This powerful feature helps you quickly identify patterns, track changes, and focus on important data points in your data.

You can access the highlighting options by right-clicking on the datagrid and selecting one of the options from the " Highlight" menu group.

Built-in Highlighting Options

The app comes with several built-in highlighting options that can be toggled on or off. These are as follows.

Blank Columns

Highlights all columns where all rows contain empty/null value for that field.

Keep in Mind
  • Even a single non-empty value in any of the rows in that column will not trigger the highlight.
  • This considers only the rows that have been fetched in to the datagrid. For example, if your query matched 10,000 records, but you’ve fetched only the first 2,000 records, then the highlight will be based on those 2,000 records only. As you fetch more, the highlight may change.

In the example blow, the "Account_Number__c" column is highlighted because all rows have empty values for that field.

Cell Changes

This option highlights the cells that are different from the previous row. This is useful for quickly identifying changes in data values across rows.

In the example below, the second row "Name" column is highlighted because the value is different from the previous row. When you sort the rows, you will need to re-apply the highlighting to see the changes based on the new order.

Selected Rows

The options Selected Rows and Selected Rows with Color highlights the rows that are currently selected in the datagrid. By default, app default color is used, but you can choose a custom color using the color picker dialog in the option Selected Rows with Color.

Selected Cells

The options Selected Cells and Selected Cells with Color highlights the cells that are currently selected in the datagrid. By default, app default color is used, but you can choose a custom color using the color picker dialog in the option Selected Cells with Color.

Custom Highlighting

Using Custom Highlighting, you can create your own highlight rules for any of the columns in the datagrid. You can define the conditions using brobench's formula engine, allowing for complex and flexible highlighting based on your data analysis needs.

To manage custom highlights, right-click on the datagrid and select Highlight -> Manage Highlights. This opens the below dialog.

Here are the various columns in the dialog:

  • Name: Descriptive name for the highlight rule
  • Color: Background color for matching cells
  • Order: Priority order (lower numbers execute first)
  • Condition: Formula expression that determines when to apply highlighting

Adding/Editing Conditions

Click on the Plus icon to open below dialog to add a new highlight rule. You can also edit an existing rule by clicking on the Pencil icon next to the rule that you want to edit.

Once you add the custom highlights, they will be shown below the built-in highlights in the right-click menu. Selecting one of those will highlight the selected column(s).

Keep in Mind
  • At this time, custom highlights cannot be used as row-level highlights. You must select one or more columns to apply the highlight.

For example, in the below screenshot, the custom highlight "Revenue more than 100000" is applied to the "AnnualRevenue" column.

Clearing Highlights

To clear the highlights, right-click on the datagrid and select Highlight -> Clear Highlights. This will remove all highlighting.