Question

How can we check Average value of Numbers in Rules Engine

  • 15 April 2022
  • 1 reply
  • 33 views

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

Userlevel 7
Badge +3

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.

Reply