Time display always from 00:00 to 23:59

Hello

I have a small problem and hope I can help me here.
I have recorded data for an evaluation of my smart meter via MQTT in my InfluxDB database.
The recording of the data works so far only I get my evaluation of the data always 24 hours (that’s what I want) always displayed from the current time.
However, I would like my evaluation to always be displayed from 00:00 to 23:59 in order to show my actual consumption during the day.
I have already looked through many settings and searched the Internet for this topic, but somehow I can’t find a suitable solution.

Can someone please help me find a solution.
Thank you very much in advance.

Best regards
Mandragora

image

To be clear, you want to see “yesterday” not “previous 24 hours”?

Hello jchh

On the picture you can see that the data is displayed from date 21.02 17:04 to 22.02 17:04.

But I want it to always be displayed from 00:00 to 23:59, regardless of whether I display my data / charts yesterday, today, 7 days, 30 days, etc.
image

I need this so that I can really evaluate my consumption on a daily basis.
I hope I have been able to explain this clearly.

Many thanks for your efforts and help.

Best regards
mandragora

1 Like

You probably need to look into the apex chart integration.

Hallo Wallyr

Thanks for the tip. I didn’t know that yet. So it’s not possible or feasible with Grafana, is it? Do I understand that correctly?

Best regards
Mandragora

I have no idea.
I just know I have Apex chart set up to something similar with electric prices.
It is just something I have copy paste s from a thread, so cant help with actual design.