Combo

Combine multiple types of charts into a single chart

Column Chart with Secondary Line

Column Chart with Secondary Line

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

An example combo chart that has a column and a line series

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