Graphing Daily Total Feeds

Jaddache · 2022-03-08T10:47:37.783Z

I am trying to graph multiple daily energy feeds on a single daily graph on a local raspberry pi based emoncms. The historical daily energy feeds are generated via input processing using the Power to kWh/d process. The Forecast solar energy feed data is generated from Solcast data using node red and loaded using the Feed API. :

http://local_host_ip/emoncms/feed/insert.json?id=feed_id&time=forecast_time&value=forecast_output&apikey=local_host_write_apikey

My difficulties are associated with the type of graph selected. If I select a Fixed Interval 86400sec graph type, the current day’s data is shown on the previous day. If I select a Daily graph type, the current day’s data is shown on the correct day however the future forecast data loaded as above is incorrect on the graph. The CSV outputs of the subject data for the two different graph types is shown below.

image1360×205 18.9 KB

As there is only one data point for each day for the forecast, I can’t imagine how the Daily graphing function can generate a different value.
Can someone point me to an explanation of the Daily graphing function or help me get the correct values displayed on my Daily graph?

Timbones · 2022-03-08T11:22:20.418Z

I think this is because the forecast_times are inserted at midday rather than at midnight, and EmonCMS is interpolating between days. If you shift the forecast_times to be aligned to midnight, that might help?

Jaddache · 2022-03-08T11:49:57.215Z

Timbones:

If you shift the forecast_times to be aligned to midnight, that might help?

It did help Tim. Thank you. The graph is aligned now with the correct values shown.
The fixed interval graph on the other hand does not appear to interpolate.

Jaddache · 2022-03-09T10:19:55.632Z

So now I have a different but related problem with the same graph.
The graph in question is used as part of a dashboard. The graph is saved as a Daily type graph in emoncms.
When the dashboard is displayed without logging in to emoncms, the interpolation that @Timbones identified above is evident in the displayed forecast (the non-shaded yellow bars) consistent with the associated data being aligned with midnight GMT (11:00 local time). This is very evident in the right most set of bars.

image988×382 22.9 KB

When the dashboard is displayed when logged in to emoncms, no interpolation is evident and the bars on the graph and the associated forecast data as expected.

image991×385 23 KB

The dashboard is intended to be public. Is there a setting on the saved graph or dashboard that I have missed?