# Chart Dashboard 2 two series of data

**URL:** <https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362>\
**Category:** Dashboard\
**Tags:** dashboard-2\
**Created:** [22 November 2024 17:54 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362 "2024-11-22T17:54:10Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mancebo77](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mancebo77/32/96647_2.png) [@mancebo77](https://discourse.nodered.org/u/mancebo77)\
**Post date:** [22 November 2024 17:54 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/1 "2024-11-22T17:54:10Z")

</div>

Hello everyone, I'm trying to insert two data series into chart.dashboard 2.0, but without success...

Can anyone help me?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/4/04be4e0fd0596de95c83d488fe0a5b124af0a099.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/b/6baa5259f55afae43214a727c803cae05d925eab.png)

Function code:

```auto
const inp = msg.payload;

//Criar um objecto para gráficos.
var outObj = [
    {
    "series": ["Eletricidade"],
    "data": [[] ], 
    "labels": ["1"]    
    }
    ,
    {
    "series": ["Gás"],
    "data": [[] ],
    "labels": ["2"]
    }
    ]

for (let item of inp ) 
{
    outObj [0].data[0].push(
        {
            x: item.Data,
            y: item.PreçoPortugal
        });
    outObj[1].data[0].push(
        {
            x: item.Data,
            y: 100
        });
}

msg.topic="";
msg.payload= outObj;
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:** [22 November 2024 18:26 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/2 "2024-11-22T18:26:00Z")

</div>

Boa noite @mancebo77, bem vindo ao Forum 🙂

Charts in dashboard 2 are simpler than in node-red-dashboard.  
You probably don't need your function node to reformat the data.

Please copy and paste here a sample of the msg.payload that you pass into the function. (Paste it as text using the `</>` button, not as a picture)

---

<div class="post-metadata">

**Author:** ![mancebo77](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mancebo77/32/96647_2.png) [@mancebo77](https://discourse.nodered.org/u/mancebo77)\
**Post date:** [22 November 2024 20:43 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/3 "2024-11-22T20:43:40Z")

</div>

Hi @jbudd,  
The payload comes from mysql, it only has one series of data, in the function I added the second series (only one line with value 100).

```auto
[{"Data":"2024-11-21T23:00:00.000Z","PreçoPortugal":107.74},{"Data":"2024-11-21T22:00:00.000Z","PreçoPortugal":116.92},{"Data":"2024-11-21T21:00:00.000Z","PreçoPortugal":122.11},{"Data":"2024-11-21T20:00:00.000Z","PreçoPortugal":125.01},{"Data":"2024-11-21T19:00:00.000Z","PreçoPortugal":116.49},{"Data":"2024-11-21T18:00:00.000Z","PreçoPortugal":84.99},{"Data":"2024-11-21T17:00:00.000Z","PreçoPortugal":64.78},{"Data":"2024-11-21T16:00:00.000Z","PreçoPortugal":33.2},{"Data":"2024-11-21T15:00:00.000Z","PreçoPortugal":29.8},{"Data":"2024-11-21T14:00:00.000Z","PreçoPortugal":33.2},{"Data":"2024-11-21T13:00:00.000Z","PreçoPortugal":33.2},{"Data":"2024-11-21T12:00:00.000Z","PreçoPortugal":50},{"Data":"2024-11-21T11:00:00.000Z","PreçoPortugal":69.39},{"Data":"2024-11-21T10:00:00.000Z","PreçoPortugal":87.8},{"Data":"2024-11-21T09:00:00.000Z","PreçoPortugal":107.99},{"Data":"2024-11-21T08:00:00.000Z","PreçoPortugal":95},{"Data":"2024-11-21T07:00:00.000Z","PreçoPortugal":75.2},{"Data":"2024-11-21T06:00:00.000Z","PreçoPortugal":65.18},{"Data":"2024-11-21T05:00:00.000Z","PreçoPortugal":64.89},{"Data":"2024-11-21T04:00:00.000Z","PreçoPortugal":65.1},{"Data":"2024-11-21T03:00:00.000Z","PreçoPortugal":75},{"Data":"2024-11-21T02:00:00.000Z","PreçoPortugal":84.99},{"Data":"2024-11-21T01:00:00.000Z","PreçoPortugal":93.96},{"Data":"2024-11-21T00:00:00.000Z","PreçoPortugal":103.5}]

```

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/d/7d31991b31ccf1d1958f8e48d81e77182d807bf0.png)

Thanks

---

<div class="post-metadata">

**Author:** ![joepavitt](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/joepavitt/32/59722_2.png) [@joepavitt](https://discourse.nodered.org/u/joepavitt)\
**Post date:** [29 November 2024 16:00 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/4 "2024-11-29T16:00:05Z")

</div>

No need for a function node as @jbudd mentioned. Here you can just set the "X" property in the Chart config to the type `key` with a value of `Data`.

Then for the `y` you can have the `key` type again, but with value `PreçoPortugal`.

For multiple lines, I'd be expecting to see additional keys in each object, which I don't currently?

---

<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:** [29 November 2024 17:45 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/5 "2024-11-29T17:45:55Z")

</div>

I guessed that the OP wants a chart like this only with the two red dots joined together.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/6/86a7c3d5043590d8ea7f82b553faca0e51c2c572.png)

However, since it was a guess, they did not show us data including points with value 100, and my first ten attempts to achieve it failed, I gave up 😵‍💫

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [30 November 2024 10:13 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/6 "2024-11-30T10:13:26Z")

</div>

> [@mancebo77](#):
>
> I added the second series (only one line with value 100

I get a 'constant' series of data from mysql itself to keep it simple. like,  
`select value1 as v1, 100 as v2 from mydatabase where...`  
usually i use this serving as minimum or maximum threshold lines in the chart...

---

<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:** [30 December 2024 10:14 UTC](https://discourse.nodered.org/t/chart-dashboard-2-two-series-of-data/93362/7 "2024-12-30T10:14:10Z")

</div>

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