Skip to main content
Contributor ⭐️⭐️
Apr 15, 2022 1:54 PM UTC
Question

How can we check Average value of Numbers in Rules Engine

Hello,

 

I’ve check documentation for Mediation and found that we can check Mediation number and Average number, but gif pictures and my Rules engine have different tools and I can’t understand why.

 

Here is the link of Docs: https://support.gainsight.com/Gainsight_NXT/03Rules_Engine/02Admin_Guides/Application_of_Statistical_Functions_in_Rules_Engine

 

Example: I have variable a=[1,3,2,5,4,1,1,2]

Target: Need extract Average value and populate another object b=Number

It would be perfect if I can extract Mediation and Average values into b and c objects.

 

Thank you!

1 reply

seth
Expert ⭐️
Apr 26, 2022 6:08 PM UTC

It occurs to me: if you aggregated your variable with a sum, and then separately with a count, then you could use a Calculated Field to divide them, and thus produce your Average. Note that I don’t think that Nulls would be counted as Zeroes.

Translate
AI Transformation @ Gainsight