question

Ulrich avatar image
Ulrich asked

My Grafana Dashboard free to use

Hello everybody,

I use Grafana professionally to monitor servers in our data center and servers of our customers.

Since our data center should use 100% photovoltaics, I came to Victron Energy. The test project was the expansion of our mobile home with all the necessary components: battery, MPPT solar charge controller, inverter, shunt and other things.

Victron Energy offers a fantastic interface with VRM. I wanted to see more data and created a Grafana dashboard.

I published this dashboard at Grafana. Everyone is welcome to load the dashboard and see how I set up the displays and how the values are calculated. Maybe you can find some ideas for your own installation.

I am very happy if other ideas are proposed here and I will try to implement them.

Grafana dashboard: https://grafana.com/grafana/dashboards/14400

greetings
Ulrich

VRMgrafana
3 comments
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

mresman avatar image mresman commented ·
You have noted that Gafana can be installed without Docker. I think this is a good idea. On the Grafana website it has a direct install to Windows. What was the purpose of Docker? What will I lose if I use the direct install method? Influx is a database?
0 Likes 0 ·
Ulrich avatar image Ulrich mresman commented ·

Hi mresman,

look here: https://community.victronenergy.com/content/kbentry/119253/how-to-run-grafanainflux-solution-natively-on-wind.html

This is my article with script to install all needed components on Windows.

Did you need help? Hask there in the comments.

Yes, InfluxDB is the database.

0 Likes 0 ·
cleverheart avatar image cleverheart mresman commented ·

Docker is a convenience that encapsulates the separate services (InfluxDB, Grafana etc)... as an alternative to installing directly in the OS.


Why? For example; I recently had some problems with my Raspberry Pi OS, so rebuilt the OS booting from an SSD instead of an SD card. Because I had made the smart decision to go Docker I didn't have to spend the time reinstalling InfluxDB, Grafana on the new OS.,. instead I just copied the docker-compose file to the new machine and started the Docker machines up. Simple. Saving re-work

There has been a significant movement recently in IT away from painstakingly hand building up machines (Pets) to machines configured by code (Cattle). While the setup up between Pets & Cattle is similar.. the "Cattle" is better over time in terms of significantly lower effort to maintain, upgrade, replicate etc.

In short the Docker approach is usually considered better IT professional practice.


0 Likes 0 ·
6 Answers
itsme avatar image
itsme answered ·

screenshot(s) would be nice ;-)


found it... didn't see it in the description

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

mvader (Victron Energy) avatar image
mvader (Victron Energy) answered ·

Nice! Thats a lot of data.

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

aabshir avatar image
aabshir answered ·

Thank you Ulrich. this is awesome.

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

dashti1995 avatar image
dashti1995 answered ·

Hello Ulrich,


I have several questions regarding Victron-Grafana dashboard. How can I reach out to you??

1 comment
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

Ulrich avatar image Ulrich commented ·

Post a new question in this forum using my name so that I will be notified. Then I'll try to answer your questions.

If you need my support for a project, you can also book me. I am an IT specialist and like to help.

0 Likes 0 ·
Ulrich avatar image
Ulrich answered ·
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

bipedalprimate avatar image
bipedalprimate answered ·

Hi @Ulrich

I have tried to download your dashboard so I can see how you managed to extract kwh values from time series point in time values such as "vebus/Ac/ActiveIn/L1/P".

When I have used the INTEGRAL function, the results vary widely as each SELECT occurs.

Download of your dashboard had a problem in that it kept asking for a datasource for "__expr__" which I could not provide.

Anyway, I examined the json version and noticed that you are also using the INTEGRAL function with MATH "/3600/1000" formula to produce what appears to be kwh values.

So I tried to replicate what you have done but I get the same varying results as each SELECT occurs just with more decimal places :-)

I eventually stumbled across setting the Max Data Points = 1 in Query Options and the result is far more stable but does not match the result from VRM Portal by a large margin.

This what I have in Edit Panel:-

1691907353854.png

And this is the resulting SELECT statement:-

SELECT integral("value")  /3600/1000 FROM "vebus/Ac/Out/L1/P" WHERE ("name" =~ /^VRM Portal Id$/) AND time >= now() - 12h GROUP BY time(12h) fill(null)

Any suggestions would be appreciated.


1691907353854.png (57.1 KiB)
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.