Skip to main content
Question

How can we check Average value of Numbers in Rules Engine

  • April 15, 2022
  • 1 reply
  • 66 views

  • Contributor ⭐️⭐️

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
Forum|alt.badge.img+9
  • Gainsight Employee ⭐️⭐️⭐️
  • April 26, 2022

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.