Different timeframes on the same panel for data comparison

Hello everyone!

I am using Grafana 11.2.2 and I am querying data from Elastic search.
I have a dashboard with multiple panels and alerts set but I am not finding a solution (even online) on what I want to do.

In 1 panel, I want to visualize the data in the timestamp I use but for different timeranges so I can do some calculations on the difference.
Let’s say we take last 1h of my data, I want to have on the same panel the same timeframe of 1h but -24h. So I can see if, let’s say, today in the last hour the data is performing better or worse than yesterday in the same hour timeframe. Then I could set an alert (maybe seeing that today I am worse 50% than yesterday for example).
But the main problem is to visualize both time ranges in the same panel. I saw that in the Query options I can set timeshift, but then it applies it to all the queries on the same panel. But each query have limited options to be set. For each of them I tried to play with the Offset as well, but did not succeed.

Is there anyone more expert in this or know how to solve it (or just say: “you cannot do it”)?

Thanks all!