It has been a long day and for the life of me I cannot see the error.
Description of test environment.
Pi with mysql.
I created a test script that pushes some large values into 150 tables every minute. This is more for monitoring data size over time at the moment. You can see from the screenshot the types of numbers we are talking about.
What I would like to to is show this data in watts as a graph?. I can get the graph up but the actual points that are logged every minute are not display in the time frame. As you can see from below the side bar has correctly interpreted the scaling but it fails to display the singular readings on the graph.
Picture below is for last 30 minutes.
Changing the graph to a table I get the following
Also in table view the time appears to be an hour our even though the mysql datetime and ini files have been updated to reflect the correct time?.
I appreciate this is a multi pronged request but what am I doing wrong. More than likely to be something silly. Just a little guidance would be great.
Granted these are huge numbers but I would have though as the scaling has interpreted terrawatts and pettawatts correctly it could have plotted the points.
In short the graph displays but not points of plotting.
In table view I get an hour out even though time zones and mysql are correct.