@stacking-mode

Whether the stacking for the chart is shown as 100% of the total or none

Quick Reference

-- @stacking-mode: percent

valid Values

String

• none

• percent

Used with @stacks

Full Example

-- @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 TRUNC(date_closed, 'MONTH'), Channel
ORDER BY TRUNC(date_closed, 'MONTH') ASC;

Example of stacking-mode: percent

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
February, 01 2017 00:00:00 +0000	referral	1149197.0

Use Cases

Use @stacking-mode: percent when you want to show the relative contribution to the whole stack of the items in the stack. Use @stacking-mode: none if you want to reset the stacking-mode