# MySQL SELECT to Line Chart

**URL:** <https://discourse.nodered.org/t/mysql-select-to-line-chart/16307>\
**Category:** General\
**Created:** [4 October 2019 10:23 UTC](https://discourse.nodered.org/t/mysql-select-to-line-chart/16307 "2019-10-04T10:23:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrefs](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@Andrefs](https://discourse.nodered.org/u/Andrefs)\
**Post date:** [4 October 2019 10:23 UTC](https://discourse.nodered.org/t/mysql-select-to-line-chart/16307/1 "2019-10-04T10:23:54Z")

</div>

Hi guys,  
I need some help please.  
I have an output like this from mysql database.  
 ![outputMysql](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/8/830fc6a15d9f9699c95e19a40c59de20f52117a6.png)  
And i want to do a line chart with values about "velocidade" for example.  
Anyone can give me some help to do that?

Thanks 🙂

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [4 October 2019 10:55 UTC](https://discourse.nodered.org/t/mysql-select-to-line-chart/16307/2 "2019-10-04T10:55:24Z")

</div>

Try a function node:

```auto
m = msg.payload

chart = []

for(x=0;x<m.length;x++){
    chart.push([m[x].temperatura,m[x].velocidade])

}

out = [
    {
        "series":["x","y"],
        "data":chart,
        "labels":[""]
    }
]
    
return {payload:out}

```

Connect it to the chart.

---

<div class="post-metadata">

**Author:** ![Andrefs](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@Andrefs](https://discourse.nodered.org/u/Andrefs)\
**Post date:** [4 October 2019 11:23 UTC](https://discourse.nodered.org/t/mysql-select-to-line-chart/16307/3 "2019-10-04T11:23:12Z")

</div>

The chart stay empty.

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [4 October 2019 11:24 UTC](https://discourse.nodered.org/t/mysql-select-to-line-chart/16307/4 "2019-10-04T11:24:56Z")

</div>

It does not if you provide the proper output data.

Is it a `msg` or a `msg.payload` ?  
if it is `msg` change the function to `m = msg`