How to display heat duration by day

[didi31]

Hi,
The time is calculated with an history_stat sensor when the heater is on.

I would like to get a bar graph with the max by day.
My code is the following:

and I get this graph

The values taken for the calculation of the 2nd of January includes the last value of the 1st of January.
I would expect to have 2.22 whilst I get 4,8
Where is my mistake?

If a zoom on the 2nd of January value, the data starts at 00:00:42

How can I start calculation from this point?
I tried someting with the filter but I don't know how to do it.

Can someone help me?

[didi31]

Do you see any reason that these points are not calculated correctly?

[dbuezas]

Interesting. With that YAML, you should be seeing exactly whatever home assistant wrote in the statistics and history tables of the db. I suggest you compare it with the values in those tables and or the built-in plotting cards

[didi31]

With the same data I get this graph with apexcharts.

witch is what I would like to have with plotly.

[didi31]

With the built-in graph, I have the same problem

I did the same calculation in SQL from the statistics table:

The work around is to draw the graph from the SQL result...