Statistics uses the wrong timestamp column

[georgh]

Describe the bug
Plotted statisitc values (5minute and hourly) are shifted on the x-axis for state-statistics.

The value listed for example at 23:10 uses the entry collected at 23:14:43.
I would have expected plotly to show the value at 23:15.

I think that is due to using the start_ts-column in statistics_short_term instead of the created_ts column.

Naming is a bit confusing and I dont see much in the offical docu about it (https://data.home-assistant.io/docs/statistics/). I am not sure why you would dump start and end of the period into the db if its always 5 min?

Screenshots

yaml

type: custom:plotly-graph
title: Verschiedene EnergieQuellen
hours_to_show: 4h
autorange_after_scroll: false
refresh_interval: auto
ha_theme: true
grid_options:
  columns: 48
  rows: 8
entities:
  - entity: sensor.total_energy
    name: normal db
  - entity: sensor.total_energy
    name: statistics db - state / hour
    statistic: state
    period: hour
    line: true
  - entity: sensor.total_energy
    name: statistics db - state / 5 min
    statistic: state
    period: 5minute
    line: true

Additional context
Add any other context about the problem here.

[georgh]

As a quick fix, values can be re-aligned via time_offset:

  - entity: sensor.total_energy
    name: statistics db - state / hour
    statistic: state
    period: hour
    line: true
    time_offset: 1h
  - entity: sensor.total_energy
    name: statistics db - state / 5 min
    statistic: state
    period: 5minute
    line: true
    time_offset: 5m

[dbuezas]

If i recall correctly the statistics api doesn't give access to other columns, I don't think there's much I can do about this.

[georgh]

Hmm maybe I am wrong but would not switching
.start to .end at line

lovelace-plotly-graph-card/src/cache/fetch-statistics.ts

Line 31 in c958dfa

x: new Date(statistics.start),

fix the problem?

If thats not returned, than that should probably be raised as an issue at the main repo?

Is there any documentation for the API hass.callWS?

[dbuezas]

End is there too:

lovelace-plotly-graph-card/src/cache/fetch-statistics.ts

Line 15 in c958dfa

end_time: end.toISOString(),

I think it may be e counter intuitive with e.g yearly statistic

[dbuezas]

You can always grab the statistics object inside map_x and use the end time