# Cant draw multiline graphs in Grafana new versions

**URL:** <https://community.grafana.com/t/cant-draw-multiline-graphs-in-grafana-new-versions/103465>\
**Category:** Dashboards\
**Created:** [September 13, 2023, 10:29am UTC](https://community.grafana.com/t/cant-draw-multiline-graphs-in-grafana-new-versions/103465 "2023-09-13T10:29:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aditha](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/aditha/32/38031_2.png) [@aditha](https://community.grafana.com/u/aditha)\
**Post date:** [September 13, 2023, 10:29am UTC](https://community.grafana.com/t/cant-draw-multiline-graphs-in-grafana-new-versions/103465/1 "2023-09-13T10:29:25Z")

</div>

Hi all,  
I am using Grafana 10.1.1. I am trying to get a multiline chart like below.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/1/6/1685d7348fe01abb3378ef18d1a3cb4bf89c2de1.png)

Above chart is received from grafana 7.3  
But In 10.11 its just received one line if I execute same query which I used in grafana 7.3.

Related Query.

SELECT

UNIX\_TIMESTAMP(time) as time\_sec,convert(action,CHAR(20)) as metric ,

SUM(hits\_count) as “Action Count”

FROM scm\_host\_op\_sp\_service\_action\_channel\_errorcode\_wise\_tps\_hourly

WHERE

$\_\_timeFilter(time)

Group by time,action

Thanks.

---

<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:** [September 13, 2023, 2:44pm UTC](https://community.grafana.com/t/cant-draw-multiline-graphs-in-grafana-new-versions/103465/2 "2023-09-13T14:44:52Z")

</div>

What is your datasource?Try the following

```auto
SELECT

UNIX_TIMESTAMP(time) as time,
convert(action,CHAR(20)) as metric ,
SUM(hits_count) as “Action Count”

FROM scm_host_op_sp_service_action_channel_errorcode_wise_tps_hourly

WHERE

$__timeFilter(time)

Group by time,action

```

Also make sure the fornat of the query is Time Series and not Table.

Also check that you do not have some Transformation that might having an effect on visualization

---

<div class="post-metadata">

**Author:** ![aditha](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/aditha/32/38031_2.png) [@aditha](https://community.grafana.com/u/aditha)\
**Post date:** [September 15, 2023, 4:17am UTC](https://community.grafana.com/t/cant-draw-multiline-graphs-in-grafana-new-versions/103465/3 "2023-09-15T04:17:31Z")

</div>

Hi, DataSource is MySQL. Finally got the solution. I transform it.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/f/3/f34a23e0c95b0a4486fbfdca217974ea5132bacb.png)  
Then my yable in grafana change it as below.  
 ![image](https://us1.discourse-cdn.com/grafana/original/3X/f/e/fe62e708753a74d877e3e49914d53529e35ea9a3.png)  
Then I can draw multiline charts.

Thanks.