# @series-types

## Quick Reference

```sql
-- @series-types: column, line
```

## Valid Types

`List`

* column
* bar
* pie
* line
* area
* combo

## Full example

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

<figure><img src="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2F6CPfEHsW4BCQpPPGQEkX%2Fimage.png?alt=media&#x26;token=37fab975-885d-41c1-992a-868b62b99e6c" alt=""><figcaption><p>Example of using series types within a combo chart</p></figcaption></figure>

| 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&#x20;