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 ?