> 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

Sets a target value for a series and highlights the series values that have met the 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="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2Fs9YtqpyCAKVfmzMEKAYn%2Fbaselines_example.jpg?alt=media&amp;token=0d0eb41a-1e8e-42b5-96f7-3fe7dfd5fd9c" 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