Area

Example area charts

Area Chart with 100% Stacking

Area Chart with 100% Stacking

-- @chart: area
-- @title: Stacking-mode - 100% normalizing a stacked chart
-- @groups: Month, Channel
-- @subtitle: An example area chart that is 100% stacked
-- @formats: currency
-- @series: Sales
-- @stacks: Channel
-- @stacking-mode: percent
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
    Channel,
	sum(amount) as Sales
FROM sales
GROUP BY Month, Channel
ORDER BY Month ASC;

MONTH	CHANNEL	SALES
January, 01 2017 00:00:00 +0000	coldcall	174647.0
January, 01 2017 00:00:00 +0000	referral	1310064.0
January, 01 2017 00:00:00 +0000	search	681444.0
January, 01 2017 00:00:00 +0000	event	502700.0
February, 01 2017 00:00:00 +0000	pr_ad	509564.0
February, 01 2017 00:00:00 +0000	search	1109141.0
February, 01 2017 00:00:00 +0000	event	417651.0