Thread Rating:
  • 4 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Esperyd´s Raspberry PI project
(06-17-2019, 07:42 PM)daromer Wrote: Yes you can. Best is IF the values only have different tags but in same series
Last solar sis have better layout for this (not pushed to hit yet) but doable with current too

Values are in the same series but still don’t understand how (for example) to sum them. Only operation I am able to do is to stack values if on graph......
Reply
You need to manually write some code for it. I can post examples later but you also have earlier in this thread.
iomagico likes this post
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
Reply
(06-18-2019, 02:56 AM)daromer Wrote: You need to manually write some code for it. I can post examples later but you also have earlier in this thread.

Yes please, if you can post one example I’ll appreciate it.

Let immagine I want to simply sum the active power coming from the 3 inverters. Remember I have 3 differente sources, so I can put the values in a serie but I don’t know how to operate math between them. Maybe I can set a variable for each value?
Reply
I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.
Reply
(Yesterday, 07:41 AM)iomagico Wrote: I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.

If you run 3 instances of the solar_pip, only modifying the serial port,  you are inserting triple data and you can not difference the inverter wich data that comes from. 

I think the best way is to change calls.json file to change response section on every folder to insert in the same meassurement (general_status) but different fields (grid_voltage1, grid_voltage2, grid_voltage3), etc, so you can differenciate and agregate data from different inverters in grafana.

Regards
Reply
iomagico Have you looked back in the thread?

Example of sum I do:
select sum(sum1) from ( select (mean(solar_input_power_1)+mean(solar_input_power_2)) as sum1 from solar where device='mpi' AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum(last) as sum1 from(select mean("charging_power") as last FROM "solar" group by device) where $timeFilter GROUP BY time($__interval) fill(null)) GROUP BY time($__interval)
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
Reply
(Yesterday, 07:06 PM)jesusangel Wrote:
(Yesterday, 07:41 AM)iomagico Wrote: I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.

If you run 3 instances of the solar_pip, only modifying the serial port,  you are inserting triple data and you can not difference the inverter wich data that comes from. 

I think the best way is to change calls.json file to change response section on every folder to insert in the same meassurement (general_status) but different fields (grid_voltage1, grid_voltage2, grid_voltage3), etc, so you can differenciate and agregate data from different inverters in grafana.

Regards

What I did was to create 3 different solar_pip folders so I can perfectly differenciate the values from different inverters.
So I can display results and I can even add values from different inverters (stacking them). What I can’t is to operate math when FROM is different.
All math operations I am able to compute are with same FROM field.
Here I am attaching two pictures from grafana.

Ps: will try the Jesuangel solution
Reply


Who read this thread?
100 User(s) read this thread:
hbpowerwall, AZ_Tekkie, Chickey, ShaneE, Minx, daromer, Sean, mike, 18650Shrink, goodnowm, AveRageJoe, BigBen, PaulKennett, Joaquinsfy, SJBW, NiVa, MichelKuenemann, Lux_Gamer, Andreas Kvernes, owitte, opus40, RudyLiPower, lgeo, dakoal, VdVoort4, Glubux, Majorphill, Elwood, coolfx, ruby2, JustJim, Korishan, A + A, PAF, FERCSA, Prahe86, Clisse, Zensay, Franky Beuselinck, Batrium, Darmok, Wattsup, Scepterr, eeesOap, BobinTN, Tristan Timmer, Frnandu Martiński, CrankyCoder, Mike C, Droid126, eAnic, Sabado, jdeadman, charlie246, monsted, camils, Zagy, 2146, wim, wimpie007, ericg, frnandu, typ49, John, Christian, Robert Baumer, Alyas Junior Abdul, Jeremy Choy, 1958 greyhound, Abarth595, Sentinal, Tango47, kktuo, civitou, neilmc, Kaspars Krumins, Off Grid Power wall, Verner A. Møller-jensen, Tychipowerwall, rebelrider.mike, kaits31, gaz, watts-on, Dan Lim, jesusangel, Gimpy_AK, fcbrand, Daggerzz, Hanssing, MetalFang, Fredd, autobd, IronSky, Mark Daniel Olsen, DrkHrs13, tamkov, silverse2m6, kot, quake101, Joost2

Forum Jump:


Users browsing this thread: 2 Guest(s)