Series Titles

Controlling how series are titled

Series Titles Overview

Series Titles are the names of the series that go in legend area

The title of the series are the same as the column that defines the series. If you wish to change the title of your series, you change the name of the column in SQL:

column as MyNewName

Underscores to Spaces

If there are underscores in the column name, they will be converted to spaces

-- @chart: Line
-- @title: Series Title Spacing
-- @subtitle: Spacing on series titles is determined by underscores
-- @formats: currency
SELECT
	TRUNC(date_closed, 'MONTH') as Month,
	sum(amount) as total_sales_amount
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH')
ORDER BY TRUNC(date_closed, 'MONTH') ASC;