"Build a panel" from a csv file already imported

[giuliomagnifico]

Hi, I’m running a Grafana server on my Raspberry PI 5 with lots of data all from Prometheus or InfluxDB and all is fine.

But now I’ve found the plugin to import the csv data and I’ve installed it, it works fine, I want to use it to import the data from my home power meter broker and display a graph. But the csv files that I can export from the energy broker is a bit weird

Here’s the file, were the above data are the 15 minutes time frames, and the left columns are the days (DD-MM-YYYY) with a 00:00 that I don’t know why is there.

and here is the file that I see on the energy broken website

Is there a way to “transform” the csv to a timeframe graph in Grafana? Thanks

[sowdenraymond]

can you share a sanitized csv file?

[giuliomagnifico]

Oh yes sorry, I forgot it. Here’s the December 2023 month with the “every 15 minutes” energy consumption: Filebin | vhanuxop3nx3jkgt

[yosiasz]

using the infinity plugin

[sowdenraymond]

i did the same, it was painful

[giuliomagnifico]

Thanks this is very useful! I’ll try to play with it!

[giuliomagnifico]

Ahah I’m not alone with Enel as a energy service provider anyway doing this every month is not a solution! Check the infinity plugin and osted above, it looks helpful, I’ll try to play with it to find a solution that will work as standard!

[giuliomagnifico]

The first two months of 2024 done:

…but I’m working on it, yeah it was very painful this

PS: @ sowdenraymond sorry I misunderstood you comment, I read it via mobile, I thought you was italian and you have already done all of this… sh*t with the same energy provider. My mistake!