# Temperature and epoch data from mysql and showing line chart problem

**URL:** <https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751>\
**Category:** General\
**Created:** [7 January 2021 20:58 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751 "2021-01-07T20:58:27Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 20:58 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/1 "2021-01-07T20:58:27Z")

</div>

Hi

I fetching temperature and date(epoch) data from mysql database and i showing that on a line chart.  
My problem is, on x-axis showing just the raw epoch data i unable the showind normal date. As you can see the y-axis looking good but on the x show epoch  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/b/ab296d52e69a95aa50963ca0042a224832e5b6ae.png)

In my function, i use this code as a input:

```auto
var data = [];
var month = [];
msg.payload.forEach(function(value) {

    data.push(value['temperature']);
    month.push(value['date']);
});

msg.payload = [{
     series: "A",
    data: [data],
    labels: month
}];
return msg;

```

I tried this option too but i was worse

```auto
var data = [{"x":Date.parse(Date()), "y":Number(msg.payload)}];

```

I sendig the nodes code which are affected on my problem.

```auto
[{"id":"c56c1651.977188","type":"ui_chart","z":"b0a4e375.4b281","name":"Chart","group":"c90ed0b1.f8ac3","order":0,"width":0,"height":0,"label":"","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"1","removeOlderPoints":"1000","removeOlderUnit":"86400","cutout":"","useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"x":2090,"y":460,"wires":[[]]},{"id":"fd88f976.4ae028","type":"function","z":"b0a4e375.4b281","name":"Prep","func":"var data = [];\nvar month = [];\nvar minutes = 1000 * 60;\nvar hours = minutes * 60;\nmsg.payload.forEach(function(value) {\n\n data.push(value['temperature']);\n month.push(value['date']);\n});\n\n\n\n\nmsg.payload = [{\n series: \"A\",\n data: [data],\n labels: month\n}];\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1890,"y":340,"wires":[["c56c1651.977188","4c7a856b.6ad5bc"]]},{"id":"c3623688.d0dfa8","type":"mysql","z":"b0a4e375.4b281","mydb":"d0b63b56.52c6c8","name":"","x":1670,"y":360,"wires":[["fd88f976.4ae028","ed27559.8b8aaa8"]]},{"id":"4c7a856b.6ad5bc","type":"debug","z":"b0a4e375.4b281","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":2150,"y":320,"wires":[]},{"id":"c90ed0b1.f8ac3","type":"ui_group","z":"","name":"Graphs","tab":"ebc81b8b.95c9e8","order":3,"disp":true,"width":"9","collapse":false},{"id":"d0b63b56.52c6c8","type":"MySQLdatabase","z":"","name":"","host":"127.0.0.1","port":"3306","db":"smh","tz":"","charset":"UTF8"},{"id":"ebc81b8b.95c9e8","type":"ui_tab","z":"b0a4e375.4b281","name":"Home","icon":"dashboard","disabled":false,"hidden":false}]

```

Thank you for your answers !

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 21:15 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/2 "2021-01-07T21:15:42Z")

</div>

What format do you wish the date/time to be?

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 21:17 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/3 "2021-01-07T21:17:35Z")

</div>

HH:mm format

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 21:20 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/4 "2021-01-07T21:20:19Z")

</div>

```auto
month.push(new Date(value['date']));

```

then in the chart node select  
HH:mm as the x axis label

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 21:24 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/5 "2021-01-07T21:24:39Z")

</div>

> [@E1cid](#):
>
> `new Date(value['date'])`

That's what i got:

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/5/c56c5659b199dacaae6ee43439b66171331bc550.png)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 21:28 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/6 "2021-01-07T21:28:24Z")

</div>

show us the full function code, its hard to see throw a key hole.

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 21:29 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/7 "2021-01-07T21:29:37Z")

</div>

There it is

```auto
var data = [];
var month = [];
msg.payload.forEach(function(value) {

    data.push(value['temperature']);
    month.push(new Date(value['date']));
});

msg.payload = [{
     series: "A",
    data: [data],
    labels: month
}];
return msg;

```

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 21:33 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/8 "2021-01-07T21:33:19Z")

</div>

I will need to see a debug of the msg.payload going into the function.

---

<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:** [7 January 2021 21:37 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/9 "2021-01-07T21:37:46Z")

</div>

> [@mac5562](#):
>
> ` series: "A",`

Series should be an array

> <https://github.com/node-red/node-red-dashboard/blob/master/Charts.md>

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 21:38 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/10 "2021-01-07T21:38:45Z")

</div>

The debug node

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/e/ae19289b7936c3eeca9c6db539974ae466226a54.png)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 21:48 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/11 "2021-01-07T21:48:22Z")

</div>

```auto
var data = [];
var month = [];
msg.payload.forEach(function(value) {

    data.push({"y":value['temperature'],"x":new Date(value['date']).toISOString());
    
});

msg.payload = [{
     series: ["A"],
    data: [data],
    labels: [""]
}];
return msg;

```

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 21:52 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/12 "2021-01-07T21:52:39Z")

</div>

> [@E1cid](#):
>
> ```auto
> var data = [];
> var month = [];
> msg.payload.forEach(function(value) {
> 
> data.push({"y":value['temperature'],"x":new Date(value['date']));
>     
> });
> 
> msg.payload = [{
> series: ["A"],
> data: [data],
> labels: []
> }];
> return msg;
> 
> ```

When i use that, i got this :  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/0/d079a183b5acfc7bce636c0e4f1f2ae04db23fcb.png)

---

<div class="post-metadata">

**Author:** ![hotNipi](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hotnipi/32/383_2.png) [@hotNipi](https://discourse.nodered.org/u/hotNipi)\
**Post date:** [7 January 2021 21:57 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/13 "2021-01-07T21:57:32Z")

</div>

Try this  
`data.push({"y":value['temperature'],"x":parseInt(value['date']));`

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 22:00 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/14 "2021-01-07T22:00:15Z")

</div>

It's working. Thank you very much !

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 22:01 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/15 "2021-01-07T22:01:24Z")

</div>

Problem solved, thank you very much everyone who helped.

---

<div class="post-metadata">

**Author:** ![hotNipi](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hotnipi/32/383_2.png) [@hotNipi](https://discourse.nodered.org/u/hotNipi)\
**Post date:** [7 January 2021 22:02 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/16 "2021-01-07T22:02:04Z")

</div>

Kind of strange that the timestamp is stored/read as string at the DB.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [7 January 2021 22:04 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/17 "2021-01-07T22:04:33Z")

</div>

Yes that through me, i missed it was a string.

---

<div class="post-metadata">

**Author:** ![mac5562](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mac5562/32/34943_2.png) [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Post date:** [7 January 2021 22:04 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/18 "2021-01-07T22:04:36Z")

</div>

Its just temporay probably i will modify the field datatype

---

<div class="post-metadata">

**Author:** ![hotNipi](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hotnipi/32/383_2.png) [@hotNipi](https://discourse.nodered.org/u/hotNipi)\
**Post date:** [7 January 2021 22:07 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/19 "2021-01-07T22:07:57Z")

</div>

And then you can omit the `parseInt` and access the `value['date']` directly

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [21 January 2021 22:08 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751/20 "2021-01-21T22:08:03Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.