Problem with filling data to bar chart


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 ?

The data needs to be formatted differently for bar charts - see

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