Schedule of hourly and daily consumption (two-tariff meter)

1

Hi.
how can I build such graphics using Grafana?

image
image1403×628 53.1 KB

SOURCE: Site Maintenance

2

This looks like very similar to the standard graph panel in Grafana with a time aggregation. Can you provide more details:

  • are you using InfluxDB? Or MySQL? Or a another db?
  • how far have you got? Have you installed Grafana and connected successfully to your database?
3

Hi.
Yes I installed and connected my DB (Mysql) correct.
I try create query for generat same result like on a picture.

That’s what I got now

image
image1904×895 85.9 KB

Of course, there are still a problems that I will need to solve.

Thanks.