# Alerts in Grids

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.

{% hint style="warning" %}
**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).
  {% endhint %}

### 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.

3. 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**.

{% hint style="info" %}
**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.
  {% endhint %}

### 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).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bdb.ai/bdb-user-documentation/platform-modules/10.0/bdb-visualization/dashboard-designer/key-configurations/alerts-in-grids.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.