> For the complete documentation index, see [llms.txt](https://docs.chartsql.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chartsql.com/product-and-community/in-development/baselines.md).

# @threshold

## Quick Reference

```sql
-- @thresholds: Sales(50000)
```

## Valid Values

`List`

Thresholds must be a comma separated list of columns that map to the columns used within the @series or @secondary-series

## Full Example

```sql
-- @chart: column
-- @title: Baselines - Average Baseline
-- @subtitle: An example column chart showing sales by month
-- @formats: currency
-- @series: Sales
-- @baselines: 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>

## Use Cases

Thresholds are good to show how a series value compares to a desired target value and especially to highlight series items which are above or below that value.&#x20;

## Example Charts