# Problems graphing multilines

**URL:** <https://discourse.nodered.org/t/problems-graphing-multilines/64561>\
**Category:** Dashboard\
**Tags:** chart\
**Created:** [30 June 2022 19:58 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561 "2022-06-30T19:58:36Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mchaves](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@Mchaves](https://discourse.nodered.org/u/Mchaves)\
**Post date:** [30 June 2022 19:58 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/1 "2022-06-30T19:58:36Z")

</div>

I'm trying to graph data from a database, but the graphs come out square, I don't know what it will be

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/3/93b4e5d2ea25473cdf184a9c94ae41f6d07e6ae9.png)

---

<div class="post-metadata">

**Author:** ![Mchaves](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@Mchaves](https://discourse.nodered.org/u/Mchaves)\
**Post date:** [30 June 2022 20:01 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/2 "2022-06-30T20:01:12Z")

</div>

```auto
var d = ["["]
for (var i=0; i < msg.payload.length; i++) 
{  
d += '{ "x":' + msg.payload[i].thetime + ', "y":' + msg.payload[i].Bat1 + '}';
if (i < (msg.payload.length-1)){
    d += ","
    } else {  
    d += "]"  
    } 
}
var a = JSON.parse(d)

var f = ["["]
for (var j=0; j < msg.payload.length; j++) 
{  
f += '{ "x":' + msg.payload[j].thetime + ', "y":' + msg.payload[j].Bat2 + '}';
if (j < (msg.payload.length-1)){
    f += ","
    } else {  
    f += "]"  
    } 
}
var b = JSON.parse(f)

var x = ["["]
for (var m=0; m < msg.payload.length; m++) 
{  
x += '{ "x":' + msg.payload[m].thetime + ', "y":' + msg.payload[m].Bat3 + '}';
if (m < (msg.payload.length-1)){
    x += ","
    } else {  
    x += "]"  
    } 
}
var c = JSON.parse(x)

msg.payload = [{
"series" : ["Bat1","Bat2","Bat3"],
"data" : [a,b,c],
"labels" : [""]
}]

return msg;
 

```

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [30 June 2022 20:04 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/3 "2022-06-30T20:04:58Z")

</div>

The dashboard line chart has various interpolation options. Maybe you want "Bezier".

---

<div class="post-metadata">

**Author:** ![Mchaves](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@Mchaves](https://discourse.nodered.org/u/Mchaves)\
**Post date:** [30 June 2022 20:13 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/4 "2022-06-30T20:13:50Z")

</div>

I already tried it, but I need all the lines to be like Bat1 and not in ladder

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [30 June 2022 20:29 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/5 "2022-06-30T20:29:45Z")

</div>

Please post a sample of your data, a minutes worth maybe.

---

<div class="post-metadata">

**Author:** ![Mchaves](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@Mchaves](https://discourse.nodered.org/u/Mchaves)\
**Post date:** [30 June 2022 20:59 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/6 "2022-06-30T20:59:00Z")

</div>

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

```auto
var sqliteTimeStamp = Date.now()
var Bat1 = msg.payload.Bat1;
var Bat2 = msg.payload.Bat2;   
var Bat3 = msg.payload.Bat3;  

msg.topic = `insert into Battery(thetime, Bat1, Bat2, Bat3) values ('${sqliteTimeStamp}', '${Bat1}', '${Bat2}', '${Bat3}')`
return msg;

```

I am inserting data every 10s to a sqlite table

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [30 June 2022 21:12 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/7 "2022-06-30T21:12:47Z")

</div>

Your join node, whenever it is triggered, will send the most recent values received on all three inputs. If it is set up wrongly that will result in repeated values in the database.

I suggest you check that it's set to send data when 3 messages are received.  
Also use just one inject node to trigger all three random number generators.

---

<div class="post-metadata">

**Author:** ![Mchaves](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@Mchaves](https://discourse.nodered.org/u/Mchaves)\
**Post date:** [30 June 2022 21:14 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/8 "2022-06-30T21:14:23Z")

</div>

Yes, you are right, the problem is the data, thanks!!!

---

<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:** [14 July 2022 21:14 UTC](https://discourse.nodered.org/t/problems-graphing-multilines/64561/9 "2022-07-14T21:14:44Z")

</div>

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