1

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.

  • Just to clarify, when you say "sum" do you mean "count", i.e. how many activities? – Demerit Sep 15 at 20:36
  • if you are drupal savvy then maybe Views with Aggregation or one of the other counting type options (calculated table, pivot, etc) – petednz - fuzion Sep 16 at 3:03
2

I think you can do this with https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport extension

| improve this answer | |
  • Thanks a lot - after installing this extension it really seems to offer what I need! – Tobias Krause Sep 16 at 7:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.