Chart Dashboard 2 two series of data

Dashboard
1

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

Can anyone help me?

image
image235×737 18.5 KB

image
image649×489 8.2 KB

Function code:

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;
2

Boa noite @mancebo77, bem vindo ao Forum :slightly_smiling_face:

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)

3

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).

[{"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
image1093×262 17.6 KB

Thanks

4

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?

5

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

image
image455×526 17.6 KB

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 :face_with_spiral_eyes:

6

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...

1 Like