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

Hi.
how can I build such graphics using Grafana?
image

SOURCE: http://www.myviralbox.com/adding-an-sdm-220-counter-to-openhab-blog-of-plarium-geektimes/

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?

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

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

Thanks.