question

Michał Kata avatar image
Michał Kata asked

Grafana problem - 3 phase data

Hi,

I have a problem how to display data from 3 phase system ? ac loads or pv production ? The formula NumberOfPhases dosn't work or I 'm doing some mistake, anyone can help with that ?


1680688254838.png

grafana
1680688254838.png (49.7 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.

2 Answers
hominidae avatar image
hominidae answered ·

...ehhrr..not quite sure where your problem is, here...but in a three phase system, the "(total) Number of Phases" is "3"...comes natural ;-)

The values for Curent and Power, for each individual phase, can be found under:

..../Ac/Consumption/Lx/Power and .../Ac/Consumption/Lx/Current (change Lx to L1/L2/L3 respectively)


5 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.

Michał Kata avatar image Michał Kata commented ·

I tried this and still doesn;t work, whet put this formule it shows no data :


1680691295337.png

0 Likes 0 ·
1680691295337.png (39.3 KiB)
hominidae avatar image hominidae Michał Kata commented ·

it is either L1, L2 or L3 in the path...not "L1/L2/L3" ... try this for L1: ....Ac/Consumption/L1/Power

Note: I don't know your complete path, do not copy the leading "dots" in my example string.

If that doesn't work, I can't help as I am organising my datasets / measuremenst in influxdb differently, so my example queries wouldn't help you.

0 Likes 0 ·
Michał Kata avatar image Michał Kata hominidae commented ·
Yeah of course, this path works for single phase, but I wont the Sum of all 3 phases like is on VRM portal
0 Likes 0 ·
hominidae avatar image hominidae Michał Kata commented ·

Do you have a grid meter? Than use: https://github.com/victronenergy/venus/wiki/dbus#grid-and-genset-meter

Otherwise, there is more than one way to do that in grafana, depending on the Version deployed, for an exampe that might help ,see: https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696

0 Likes 0 ·
Michał Kata avatar image Michał Kata hominidae commented ·

in that way i can only display 3 separate measurments :


1680693939493.png

0 Likes 0 ·
1680693939493.png (51.0 KiB)
hominidae avatar image
hominidae answered ·

You didn't read the other response...use a transformation to combine these three field into a single one.

Here's a quick example, combining all Power Values (Battery, Grid, PV) from my site into the SUM (of all power values) - just as an example, as technically it does not make much sense, doesn't it:

1680772992350.png

I short:

  1. Create a "normal" query for each field.
  2. select the "last" value
  3. group by "fill(previous)
  4. give each query an Alias Name

...then create a simple transformation of type "add field from calculation" like this:

1680773190803.png

in short:

  1. type: add field from calculation
  2. field name: select the Aliases, that you wish to be part of the calculation
  3. Type of Calculation: "Total".
  4. optionally, give the new field an Alias- Name to be displayed (default will be "Total").

now, use your existing queries for L1, L2 and L3 accordingly.

Hope this helps.


1680772992350.png (177.0 KiB)
1680773190803.png (73.1 KiB)
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.

Michał Kata avatar image Michał Kata commented ·
Thank you so much for your explenation, now it works very very well, thanks a lot
0 Likes 0 ·