I have an influxdb database where data from my smart meter is stored via node-red. I have some nice Grafana Dashoboards and happy so far.
There is only one thing i can´t find any information about. I want the total consumption of the last day.
I know it is possible to say the last 24h or from 2021-02-01 00:00 to 2021-02-01 23:59
What i want is the graph always displaying the day before from 00:00 to 23:59. I do not want to do this manually via the absolute time range as only this graph should show this information.
Anyone any hint how i can do this?