Daily consumption shows time in timeline instead of the day

[danieldw]

Hello,

I have a database (Maria DB 10 from Openhab) in this is in 30s cycle the current meter reading.

Now I want to calculate the daily consumption with Grafana and display it graphically from the last days.

The works so far, only he always calculates from 02:00-02:00. I can still live with it. But unfortunately it always shows only the time in the graphic, only when I go over it with the mouse I see the date. How can I change this?

Thanks a lot

[mattabrams]

welcome to the forum, @danieldw

you might want to spend some time exploring the bar chart plugin in Grafana. It uses a different data model than the timeseries panel, so you will need to adjust your data using transformation or on the DB side.

But, it can group values along the x axis according to arbitrary strings, like the days of the week. Perhaps this could work?

Bar chart