@threshold

Sets a target value for a series and highlights the series values that have met the threshold

Quick Reference

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

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

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.

Example Charts