Alerts in Grids

Configure Alerts in the Grid charting component to visually flag values that meet specific conditions.

Configuring Alerts in the Grid charting component allows you to implement a system of conditional styling that automatically highlights cells or rows based on the data values they contain. This feature goes beyond standard charting by applying immediate visual emphasis to tabular data, essentially turning the grid into a live monitoring tool.

You define Alerts using specific rules (e.g., if Stock Level $<500$, or if Project Status is 'Overdue'). When a data value satisfies a rule, the Grid component instantly applies a pre-defined style, such as:

• Background Color Changes: Turning a cell red to indicate a critical breach or yellow for a warning.

• Text Styling: Making the font bold, changing its color, or applying an underline to draw the eye.

• Icons/Indicators: Placing a small warning symbol or a status icon next to the value.

This functionality is crucial for exception reporting within dashboards, as it enables users to quickly scan a dense table of data and instantly identify items that require action or attention without needing to sort or filter the entire dataset.

Prerequisites:

• Drag and drop the Grid component onto the canvas.

• Assign a data connection to it.

• Select the field you want to evaluate.

• In Dataset Properties → Column Type, set that field’s Column Type to Numeric (required for numeric alert rules).

Configure alerts (Indicator tab)

1. With the Grid selected, open the Indicator tab to configure alert settings.

2. Set the following Alert properties:

Show Alert

• Show Alert: Enable this option to view the alerts on scorecards (Grid).

Alert Column

• Alert Column: Choose the column on which alerts should be applied.

Alert by

Choose one of the three alert modes:

• Comparison Compare a column against a Compare Value using an operator (e.g., >, <, =, ≥, ≤).

  • Example: Revenue > 1000000 → color cell Green.

  • Configure color/icon (if provided under Custom Properties).

• Range Apply colors based on where a value falls within a min / mid / max (or multiple) ranges.

  • Example:

    • < 0 → Red,

    • 0–1000 → Amber,

    • > 1000 → Green.

• Static Comparison Compare a column against static values listed in the Value text area.

  • Example: Status in {‘Delayed’, ‘Blocked’} → Red; ‘On Track’ → Green.

Custom Properties

• Configure Comparison and Alert options (e.g., color, icon, rule labels) as provided in this section.

1. Click Save to store the alert configuration for the selected field value.

Show data & preview

• Show Data: Enable this option to view the data.

• Click Preview to see the applied alerts in the Grid.

Examples

• Comparison: AvgHandlingTime > 300 → highlight cell Red.

• Range:

  • < 70 (Low) = Red,

  • 70–90 (Medium) = Amber,

  • > 90 (High) = Green.

• Static Comparison: Status ∈ {‘Critical’, ‘High’} = Red; ‘Medium’ = Amber; ‘Low’ = Green.

Tips:

• Ensure Column Type = Numeric for numeric metrics; text columns work best with Static Comparison.

• Keep rules mutually exclusive to avoid ambiguity (one value should match one rule).

• Name rules clearly in Custom Properties if labels are supported (e.g., “SLA Breach”, “Within Target”).

• Combine alerts with Sorting or Filters in Grid to surface critical rows quickly.

Troubleshooting

• No color/alert shown: Confirm Show Alert is enabled and Alert Column targets the correct field.

• Rules not firing: Check operator/thresholds in Comparison or Range; verify Numeric column type for numeric rules.

• Static list not working: Verify the exact value text and delimiter format in the Value text area.

• Everything highlighted or nothing highlighted: Simplify rules and test one mode at a time (Comparison vs Range vs Static Comparison).