@series-types

Describes the chart types to apply to individual series when the @chart: combo is defined

Quick Reference

-- @series-types: column, line

Valid Types

List

• column

• bar

• pie

• line

• area

• combo

Full example

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

Example of using series types within a combo chart

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

Use Cases

Use @series-types when you need to define combo chart