# How to chart multiple time series from a single SQL query?

**URL:** <https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956>\
**Category:** Grafana\
**Tags:** templating, query-help\
**Created:** [July 24, 2024, 7:50am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956 "2024-07-24T07:50:39Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![yurarar](https://avatars.discourse-cdn.com/v4/letter/y/ea5d25/32.png) [@yurarar](https://community.grafana.com/u/yurarar)\
**Post date:** [July 24, 2024, 7:50am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/1 "2024-07-24T07:50:39Z")

</div>

HI!  
I can’t chart multiple time series using PostgreSQL:

Query:

SELECT  
DATE\_TRUNC(‘month’, CDate) as month,  
DocumentTypeName,  
count() as “Amount”  
FROM table  
GROUP BY DATE\_TRUNC(‘month’, CDate), DocumentTypeName  
ORDER BY month

Grafana builds dashboard correctly only with specified DocumentTypeName with condition WHERE. I don’t want to add many queries but visualize in one query.

Similar problem was solved in [Grafana: How to chart multiple time series from a single SQL query?](https://community.grafana.com/t/grafana-how-to-chart-multiple-time-series-from-a-single-sql-query/55972) , but the solution qoesn’t work in my case.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/9/a/9a8d9d8d61f8bef1000f6b9fa6e269a956e5bada.jpeg)

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [July 24, 2024, 9:00am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/2 "2024-07-24T09:00:29Z")

</div>

try

```auto
SELECT
DATE_TRUNC(‘month’, CDate) as month,
DocumentTypeName as metric,
count() as value
FROM table
GROUP BY DATE_TRUNC(‘month’, CDate), DocumentTypeName
ORDER BY month

```

and make sure timeseries is selected for Format

---

<div class="post-metadata">

**Author:** ![yurarar](https://avatars.discourse-cdn.com/v4/letter/y/ea5d25/32.png) [@yurarar](https://community.grafana.com/u/yurarar)\
**Post date:** [July 24, 2024, 10:21am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/3 "2024-07-24T10:21:52Z")

</div>

Can’t find the bottom for time series/ table format.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/a/f/afdd4e89b6cd2ce6d086c6d8ad8423960c82e54d.jpeg)

---

<div class="post-metadata">

**Author:** ![yurarar](https://avatars.discourse-cdn.com/v4/letter/y/ea5d25/32.png) [@yurarar](https://community.grafana.com/u/yurarar)\
**Post date:** [July 24, 2024, 1:56pm UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/4 "2024-07-24T13:56:19Z")

</div>

Can u give an advice where is it, please?

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [July 24, 2024, 2:11pm UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/5 "2024-07-24T14:11:28Z")

</div>

maybe clickhouse does not have it

![image](https://us1.discourse-cdn.com/grafana/original/3X/b/d/bd8692de9f889d42a5ad40b94ebf54c5b53a0110.png)

did you try that query? and what result does it give you

```auto
SELECT
DATE_TRUNC('month', CDate) as month,
DocumentTypeName as metric,
count() as value
FROM table
GROUP BY DATE_TRUNC('month', CDate), DocumentTypeName
ORDER BY month

```

---

<div class="post-metadata">

**Author:** ![yurarar](https://avatars.discourse-cdn.com/v4/letter/y/ea5d25/32.png) [@yurarar](https://community.grafana.com/u/yurarar)\
**Post date:** [July 25, 2024, 6:49am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/7 "2024-07-25T06:49:32Z")

</div>

Yes, I tried. The same result. My query was similar.

---

<div class="post-metadata">

**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\
**Post date:** [July 25, 2024, 11:08am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/8 "2024-07-25T11:08:46Z")

</div>

sure, you have selected “Time series” as Format?  
Are you able to show us the raw “Table view”?

or try “Partition by values” as transformation.

Jo

---

<div class="post-metadata">

**Author:** ![yurarar](https://avatars.discourse-cdn.com/v4/letter/y/ea5d25/32.png) [@yurarar](https://community.grafana.com/u/yurarar)\
**Post date:** [July 25, 2024, 2:21pm UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/9 "2024-07-25T14:21:39Z")

</div>

Thanks! I used ‘partition by values’ in Transformation, now it works.

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [July 26, 2024, 6:00am UTC](https://community.grafana.com/t/how-to-chart-multiple-time-series-from-a-single-sql-query/126956/10 "2024-07-26T06:00:13Z")

</div>