Problem with filling data to bar chart

Dashboard
1

Hi,

I have 200 values in a database I want to show in a chart.
As the data is on a daily base, I would prefer to use a bar chart.

BUT ... when I fill the data into a line chart it looks perfectly fine and I get one value per day. When I fill it into a bar chart all I get is one bar with the latest value. The whole time information is lost.

I transfer the data this way:


msg.topic = "TimeLineBarChart";
msg.timestamp = parseInt(msg.payload.Timeseries);
msg.payload = parseFloat(msg.payload.Value);

return msg;

and in the database it looks like this:

Timeseries	        Timestamp	                        Parameter	              Value
1577923200000	2020-01-02 00:00:00.000	Energy_Daily_Sum		2.66
1578009600000	2020-01-03 00:00:00.000	Energy_Daily_Sum		2.05
1578096000000	2020-01-04 00:00:00.000	Energy_Daily_Sum		0.28
1578182400000	2020-01-05 00:00:00.000	Energy_Daily_Sum		0.67

Any idea what I have to do to get a nice bar chart out of this ?
BR
G

2

The data needs to be formatted differently for bar charts - see https://github.com/node-red/node-red-dashboard/blob/master/Charts.md

3

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