# Thresholds

ChartSQL introduces @thresholds to emphasize if a series item has exceeded (or not met) a particular target value.

```sql
-- @chart: column
-- @title: Baselines - Average Baseline
-- @subtitle: An example column chart showing sales by month
-- @formats: currency
-- @series: Sales
-- @thresholds: Sales(50000)
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
	sum(amount) as Sales
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH')
ORDER BY TRUNC(date_closed, 'MONTH') ASC
```

<figure><img src="/files/gwKyBu3l6WXw4tYFqzrc" alt=""><figcaption><p>An example column chart with a baseline</p></figcaption></figure>

## Thresholds Directives Overview

* `@hresholds`: Specifies the series to which the thresholds will be applied. By default, the target for a threshold is the average of the series. You can specify custom targets.
  * average (default):&#x20;
  * a number: Specify a hard coded number for the series threshold
  * column: Specify a column from the dataset that sets the threshold for the series item
* `@threshold-styles`(optional): &#x20;
  * success (default): Series item will be green if met
  * alert: Series item will be blue if met
  * warning: Series item will be yellow if met
  * danger: Series item will be red if met
  * color: A custom color for the series item
* `@threshold-criteria`(optional): By default, a threshold is activated when the series item exceeds the target value. You can also activate it when it&#x20;
  * above (default): When the series item is above the threshold, then it will be activated
  * below: When the series item is below the threshold, then it will be activated
* `@threshold-lines` (optional):
  * auto (default): Defaults to a baseline, unless we are using thresholds from a column, and the values within the column differ then we will use an item line.
  * baseline: Will be rendered as a line across the whole series. When the target value is from a column, the first value is used to create the line.
  * item: Will be rendered as a line across the particular series item. Used when each series item has a different threshold value
  * none: Do not render the threshold lines, only the style will be activated when the threshold is met.&#x20;

## Examples

A column chart showcasing sales with a threshold for the target sales we would like to hit

```sql
-- @chart: column
-- @title: Baselines - Average Baseline
-- @subtitle: An example column chart showing sales by month
-- @formats: currency
-- @series: Sales
-- @thresholds: Sales
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
	sum(amount) as Sales
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH')
ORDER BY TRUNC(date_closed, 'MONTH') ASC
```

<figure><img src="/files/gwKyBu3l6WXw4tYFqzrc" alt=""><figcaption></figcaption></figure>

A chart with multiple baselines with specified types:

```sql
-- @chart: column
-- @title: Baselines - Multiple Baseline Types on one Series
-- @subtitle: An example column chart showing sales by month
-- @formats: currency
-- @series: Sales
-- @baselines: Sales, Sales, Sales
-- @baseline-types: average, min, max
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
	sum(amount) as Sales
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH')
ORDER BY TRUNC(date_closed, 'MONTH') ASC
```

<figure><img src="/files/hA04UBtxTjnjlOkhClf9" alt=""><figcaption></figcaption></figure>


---

# 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.chartsql.com/product-and-community/in-development/baselines-1.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.