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.

2
  • Just to clarify, when you say "sum" do you mean "count", i.e. how many activities?
    – Demerit
    Sep 15 '20 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 '20 at 3:03
2

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

1
  • Thanks a lot - after installing this extension it really seems to offer what I need! Sep 16 '20 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.