Is it possible to calculate the geometric mean using pi analysis?
Unfortunately, we have no function to do this operation directly. But if my math is correct(?), then perhaps you could try something similar to below?
Analysis Service's array operation became available in PI Analysis Service version 2018+ (I believe).
Please correct me as I don't trust my math skills anymore.
Also, please vote for this idea to get a product(Math):Equivalent to TagTot using multiplication, for example, to calculate a geometric mean – User Feedback for OSIsoft Produc…
Thanks Jinmo ,
Where are you getting ArrayLength() and MapData() ? i cant see it in the list of functions . We are running PI system explorer 2018 SP2 and SDK version 22.214.171.12450.
The array function is added in more recent versions.
To check the version of your PI Analysis Service component, you have to remote into the node that hosts PI Analysis Service. The control panel may be the easiest to check from. This has to be above 2.10.0
My version 2.9.5
Definitely worth the upgrade for all the new features and bug fixes !
Why is it that i can see MapData() and ArrayLegth() in Help Menu . But not use them?
It is probably because you have the upgraded AF Client component to 2018+ but not the PI Analysis Service itself.
The help file belongs to the AF Client component; and PI Analysis Service depends on this component to communicate with AF and PI Data Servers. It is possible to upgrade only the AFClient. The other way around is not.
Retrieving data ...