Statistic - week vs day - inconsistent results

[luissimoes]

I have an increasing energy sensor - I derived other sensors from it to get the daily, weekly and monthly total (they reset at the specific points)

In case 1 (figure1), I am using the statistic sum over a period of 1d and filter by delta
In case 2 (figure 2) I am using the statistic sum over a period of 1W and filter by delta.

case1: If I add the values for the day to get the weekly value I get eg for the first week 72.9 and 79,5 for the week after.
case 2: the weekly values are different (less)

Why are they different? why is this not the same and what has to be set

Figure 1

Figure 2

Code (relevant part)

  - entity: sensor.bitshake_smartmeterreader_mt681_total_in
    texttemplate: '%{y:.2f}'
    name: consumed
    type: bar
    statistic: sum
    period: day
    filters:
      - filter: i>0
      - delta
      - fn: |
          ({ys,xs,hass, vars}) => ({
            xs: [...xs, new Date().setHours(0,0,0)],
            ys: [...ys, hass.states['sensor.from_netz_daily'].state],
          })

Appreciate the insights !!!!

Luis

[dbuezas]

My guess is that you have home assistant configured to start of the week on Mondays but you are adding them starting on Sunday:

• Sunday 7th to Saturday 13th = 10.28+6.92+22.06+8.17+7.08+9.64+8.8 = 72.95
• Monday 8th to Sunday 14th = 6.92+22.06+8.17+7.08+9.64+8.8+8.31 = 70.98

[luissimoes]

Hi David,
thanks for responding.
Well that is exactly what I don't understand because it isn't defined so, and anyhow the statistic is done in plotly right?

First the status:

• First day of the week is Sunday (see picture)
• The sensor for weekly values, counts from Sunday to Saturday (see picture)
• Plotly doesn't

So I assume that for the statistic in Plotly, somewhere, there is a definition of the first day of the week, since when we say week for period, and Plotly is adding values (for instance daily), it has no connection to HA.

Where does Plotly know from how to count a week? (if we ask it to add the sum of daily values over a week)
Where can we set it?

thanks!

[dbuezas]

No, the statistic is a different api of home assistant, it is not plotly processing. I suggest you try the same plots with the standard history and statistics cards and home assistant. I believe you will see the same result, in which case you can open a bug report to home assistant.

https://www.home-assistant.io/dashboards/statistics-graph/

[luissimoes]

Thanks!
You are right - (what else? ;-). - but seriously: many thanks again)

Luis