Answers.Body: <p>I think you can do this with  <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport</a> extension</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-16T07:23:55.030Z
Answers.Text: Thanks a lot - after installing this extension it really seems to offer what I need!
Answers.UserDisplayName: Tobias Krause
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-16T02:13:03.743Z
Answers.LastActivityDate: 2020-09-16T02:13:03.743Z
Answers.UserDisplayName: eileen
Body: <p>I am quite new to CiviCRM but I have programming skills with Drupal so I am looking for a best practice for our needs - and if programming is needed I would appreciate any links / information / hint how ro so that well in CiviCRM.</p>
  <p>We have some custom fields on activities where we store some data like campaigns (this data is stored in three simple text fields where campaign names are saved - it has nothing to do with Civi) and for newsletter unsubscriptions we store the reasons why people unsubscribe (this is stored in Activity details field).</p>
  <p>What we now need is a report showing us the sums of Activities gained by campaigns and unsubscription reasons. For that Civi need to sum up the Activities of the current month by the values in the fields.</p>
  <p>In short: we need a list of the values stored in a period in a custom field of the activities with the sum of activities which have this value in the corresponding field.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-15T20:36:30.870Z
Comments.Text: Just to clarify, when you say "sum" do you mean "count", i.e. how many activities?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-16T03:03:49.660Z
Comments.Text: if you are drupal savvy then maybe Views with Aggregation or one of the other counting type options (calculated table, pivot, etc)
Comments.UserDisplayName: petednz - fuzion
Tags: <civireport><activities><reports><custom-reports>
Title: Report of activities with sums on custom fields
ThreadText: # Report of activities with sums on custom fields
  
  (Asked by: username_0 on 2020-09-15)
  
  I am quite new to CiviCRM but I have programming skills with Drupal so I am looking for a best practice for our needs - and if programming is needed I would appreciate any links / information / hint how ro so that well in CiviCRM.
  
  We have some custom fields on activities where we store some data like campaigns (this data is stored in three simple text fields where campaign names are saved - it has nothing to do with Civi) and for newsletter unsubscriptions we store the reasons why people unsubscribe (this is stored in Activity details field).
  
  What we now need is a report showing us the sums of Activities gained by campaigns and unsubscription reasons. For that Civi need to sum up the Activities of the current month by the values in the fields.
  
  In short: we need a list of the values stored in a period in a custom field of the activities with the sum of activities which have this value in the corresponding field.
  
  **Tags:** civireport, activities, reports, custom-reports
  
  > **Comments:**
  > **username_1**: Just to clarify, when you say "sum" do you mean "count", i.e. how many activities?  
  > **username_2**: if you are drupal savvy then maybe Views with Aggregation or one of the other counting type options (calculated table, pivot, etc)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2020-09-16. Score: 2 | Accepted answer
  
  I think you can do this with <https://github.com/username_3mcnaughton/nz.co.fuzion.extendedreport> extension
  
  > **Comments:**
  > **username_0**: Thanks a lot - after installing this extension it really seems to offer what I need!  
  
  ---
  
  