-- @chart: combo
-- @title: Combo - Column Chat with Secondary Line
-- @subtitle: A combo chart with a column series and a secondary line series
-- @category: Channel
-- @series: TotalDeals
-- @secondary-series: ConversionRate
-- @series-types: column, line
-- @formats: currency, percent
SELECT
Sub.*,
ROUND(WonDeals / TotalDeals * 100, 1) as ConversionRate
FROM (
SELECT
Channel,
CAST(count(*) AS FLOAT) as TotalDeals,
SUM(CASE WHEN Status = 'Won' THEN 1 ELSE 0 END) as WonDeals
FROM Sales
WHERE Status = 'Won' or Status = 'Lost'
GROUP BY Channel
) as Sub
CHANNEL
TOTALDEALS
WONDEALS
CONVERSIONRATE
coldcall
206.0
37.0
18.0
referral
1069.0
243.0
22.7
search
344.0
66.0
19.2
event
427.0
112.0
26.2
pr_ad
110.0
21.0
19.1
An example combo chart that has a column and a line series
