Calculating average from categories

Answered

Follow

Mario Galea

• August 07, 2015 13:48

I have a category field "Rating" in a related app containing either 1 or 0.5 or 0.

In the working app I'm calling it with @All of Rating

Now I want to take the average of these categories, but I can't manage to transform the individual category results into numbers.

Can anyone help?

0

• 

  Rainer Grabowski

  • August 07, 2015 15:14

  Hi Mario,

  this code should work:

  var rat = @All of Rating
  
  var ratSum = 0
  for(var i = 0; i < rat.length; i++){
  ratSum +=parseFloat(rat[i])/rat.length
  };
  ratSum
  

  The numbers in the categories are strings(text); parseFloat() changes them to numbers so that ratSum+= can add them all.
  .length counts how many category fields are related. If you devide the ratSum by the number of related categories you get the average value.

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Mario Galea

  • August 07, 2015 15:19

  thanks a lot Rainer, both for code and explanation =)

  0

  Comment actions Permalink
• 

  Scott Anderson

  • February 29, 2016 15:26

  I have a similar challenge but with all fields being in the same app.  

  I am trying to calculate the average of several individual category fields.  There are about 8 category fields with the category options of each field being "0,1,2,3".  I am trying to get the average of these various fields into a separate calculation field.  Thank you. 

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • March 01, 2016 13:13

  Hi Scott,

  if all fields always have a value that's simply: 

  (+(@field1) + +(@field2) + +(@field3) + ...)/8

  If a field can be empty, but you only want to get the average of fields with values: 

  var arrFields = [@field,@field2,@field3 ...,@field8];
  var sum = 0;
  var numberValues = 0
  for(var i = 0; i < arrFields.length; i++){
  if(arrFields[i] != null){
  numberValues++
  sum +=+(arrFields[i]);
  }};
  sum/numberValues

  If a field can be empty, but you want to get the average of all 8 fields : 

  var arrFields = [@field,@field2,@field3 ...,@field8];
  var sum = 0;
  for(var i = 0; i < arrFields.length; i++){
  sum += +(arrFields[i]);
  };
  sum/arrFields.length

  Rainer

  0

  Comment actions Permalink
• 

  Scott Anderson

  • March 03, 2016 21:36

  Excellent!  Thank you Rainer I will try it out.  Thank you!

  0

  Comment actions Permalink

Please sign in to leave a comment.