> 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/reference/directives/baseline-types.md).

# @baseline-types

## Quick Reference

```sql
-- @baseline-types: min, max, average, median
```

## Valid Values

`List`

A comma separated list of types that matches the order of columns defined in @baselines

* average
* min
* max
* median

{% hint style="info" %}
Used in conjunction with [@baselines](/reference/directives/baselines.md)
{% endhint %}

## Full Example

```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>

## Use Cases

By default, 'average' is used for all baselines. You use baseline-types to override when you want something other than average.

## Example Charts

<table data-view="cards"><thead><tr><th data-card-target data-type="content-ref"></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="/pages/XLVj0yEk4zl6Ziw7DfcD">/pages/XLVj0yEk4zl6Ziw7DfcD</a></td><td></td><td></td><td></td><td><a href="/files/gwKyBu3l6WXw4tYFqzrc">/files/gwKyBu3l6WXw4tYFqzrc</a></td></tr><tr><td><a href="/pages/XLVj0yEk4zl6Ziw7DfcD#multiple-baselines-for-one-series">/pages/XLVj0yEk4zl6Ziw7DfcD#multiple-baselines-for-one-series</a></td><td></td><td></td><td></td><td><a href="/files/hA04UBtxTjnjlOkhClf9">/files/hA04UBtxTjnjlOkhClf9</a></td></tr></tbody></table>
