Compare two days of the same entity

Hi,

I’m interested to know if there are some way to better compare the same entity on different days, weeks/months, typically if I want to compare the power consumption(or production) of some devices?
I was thinking that comparing different day could be displayed in trend chart while comparing month could be with some histogram?
I’ve not found a way to see data than the default trend plot

Thank you very much!

Just a precision: I don’t expect this to be in a card, but something in parallel of the dashboards to make some analysis

Seems a bit confusing for me … as you are talking about cards
If you are looking for a card, you could use apexcharts where you have two data ‘series’ for the same entity. One of those series you could give a ‘offset’ along your req.

Days?

Yes.

Weeks and months?

Not unless you keep that much history.

I use an SQL sensor to get yesterdays cost so I can do this:

Screenshot 2024-03-05 at 19-28-27 Overview – Home Assistant

The goal is not to have every point for month and month, but some total values for each day/week/month/year and more specifically, to be able to compare them.