Help with history-graph

[ukro]

Hey,
is it possible to make a straight line wit x=start->end y=last sensor value?
As it is 24hour graph i can instantly compare usage on the same time a day before, if its higher or lower.
Thank you for any help.
P.S. i want ot use history graph as it is showing 24hours timeline

  - type: history-graph
    entities:
      - entity: sensor.spotreba_denni_celkem
    hours_to_show: 24
    refresh_interval: 600
    title: Dnes spotreba celkem

[Burningstone]

I suggest using the utility meter to track consumption of devices.

[ukro]

The point is it is tracking and working as i wanted, that is not an issue.
But i want a line on the graph so ican can visualy instantly compare previous day in the exact time that im in now

[Burningstone]

I don’t think you can do this with the history graph, maybe with Grafana charts but I’m not so experienced when it cones to charting.

[ukro]

@Burningstone

Grafana charts

Thx, it seems harder than it needed to be for me
If somebody will want here link:

Show Grafana Graphs in Home-Assistant

This is a Proof of Concept! I tried to display grafana graphs in home-assistant and found a solution. Step 1: Grafana is able to render PNG files from a Panel via API For this purpose you have to share a panel and use the link “Direct link rendered image” as shown in the following image [Grafana_Renderer] The resulting link looks like this: `http://[User]:[Password]@[IP or hostname of grafana]:3000/render/dashboard-solo/db/aussenbedingungen?orgId=2&panelId=1&theme=light&width=500&height=2…

i will keep as i t is then…

[Burningstone]

It’s not that difficult and setting up influxdb is anyway something I’d recommend for everyone planning to keep long-term data of Home Assistant. Here’s an easy guide to set both up.

[tom_l]

You can do it with an SQL sensor:

Utility Meter - Day minus 1 consumption ideally till the same time

Hello, I solved using the SQL option. The idea is to create a sensor using the SQL integration that always return the latest value of the shifted time period. For example now is 9.32 AM 09/21, the sensor will return the measurement of the 9.32 AM of the 09/20. That sensor is added to your config.yaml and using a history chart you can plot current value plus any shifted series (the sensor will record its history as any other one so you can plot a linear chart) This is my SQL code: SELECT max…

[ukro]

Wow this is even better that i wanted. Will give it a shot !!!

[ukro]

Like a charm, thx

[Burningstone]

Oh, I’m sorry, I somehow understood it differently, didn’t understand that you want it like this. Anyway, glad you got it solved

[ukro]

My english not good