Answers.Body: <p>You would do this with an extension. Check out the <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow">Summary Fields</a> extension for inspiration. It's similar to your goal, just geared toward donations and event participation.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T16:32:06.397Z
Answers.LastActivityDate: 2015-10-13T16:32:06.397Z
Answers.UserDisplayName: Nicholai
Answers.Body: <p>Not that I know of. Probably you will need to write your own (relatively simple) sql query within a hook (or a function called by rules). Check out the <a href="http://www.tutorialspoint.com/mysql/mysql-avg-function.htm" rel="nofollow">mysql docs for AVG</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T15:30:03.537Z
Answers.LastActivityDate: 2015-10-13T15:30:03.537Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>Not sure what you are trying to do exactly but possibly CiviRules (<a href="https://civicrm.org/extensions/civirules" rel="nofollow">https://civicrm.org/extensions/civirules</a>) would enable you to create specific actions and conditions for this</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T15:51:27.197Z
Answers.LastActivityDate: 2015-10-13T15:51:27.197Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>We want to implement a feedback system for services (these would be CiviCRM Contacts). Think of it like eBay feedback with an overall rating and some sub-categories like speed of dispatch, comms, description of item, etc.</p>
  
  <p>Each of these ratings would be stored as a Custom Field against each Contact.</p>
  
  <p>Feedback would be gathered via Activities. Could Civi or Drupal Rules be used to calculate averages (based on multiple Activity submissions) and update the custom fields on the Contact?</p>
  
Tags: <civirules><drupal-rules>
Title: Could Civi or Drupal Rules be used to aggregate ratings for services?
ThreadText: # Could Civi or Drupal Rules be used to aggregate ratings for services?
  
  (Asked by: username_0 on 2015-10-13)
  
  We want to implement a feedback system for services (these would be CiviCRM Contacts). Think of it like eBay feedback with an overall rating and some sub-categories like speed of dispatch, comms, description of item, etc.
  
  Each of these ratings would be stored as a Custom Field against each Contact.
  
  Feedback would be gathered via Activities. Could Civi or Drupal Rules be used to calculate averages (based on multiple Activity submissions) and update the custom fields on the Contact?
  
  **Tags:** civirules, drupal-rules
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2015-10-13. Score: 4
  
  You would do this with an extension. Check out the [Summary Fields](https://civicrm.org/extensions/summary-fields) extension for inspiration. It's similar to your goal, just geared toward donations and event participation.
  
  
  ---
  
  ### Answer by username_2 on 2015-10-13. Score: 1
  
  Not that I know of. Probably you will need to write your own (relatively simple) sql query within a hook (or a function called by rules). Check out the [mysql docs for AVG](http://www.tutorialspoint.com/mysql/mysql-avg-function.htm).
  
  
  ---
  
  ### Answer by username_3 on 2015-10-13. Score: 1
  
  Not sure what you are trying to do exactly but possibly CiviRules (<https://civicrm.org/extensions/civirules>) would enable you to create specific actions and conditions for this
  
  
  ---
  
  