@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

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
Last updated
Was this helpful?