Hi ,

Is it possible to calculate the geometric mean using pi analysis?

Regards,

Alan

Hi ,

Is it possible to calculate the geometric mean using pi analysis?

Regards,

Alan

- 2 people found this helpful
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.

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…