In Civi + Drupal latest, we have a number of campaigns that last for a year or more. We know their start and end dates, but don't particularly want to manually change their status to show whether they are 'In progress' or not. Start and end dates are sufficient for that for us.

We'd like to create a chart or at least a View (or maybe a Report?) that shows the number of campaigns currently active in any particular month.

I tried CiviVisualise but in 5.21 get a database error that says its installation failed.

So... any ideas of how to create a View that aggregates the active campaigns in any particular month? I am thinking I might be missing something very obvious here, so grateful for any thinking that can put me right. From such a View we can then create a Chart using Drupal Charts.

  • I'm not sure you can do this as you would need to get a query that takes a month as an input and returns the campaigns (or number of them) in that month; then you'd need that query to run for a specified list of months to generate your dataset. I don't think this can be done with views, though it's fairly easy to do in code, but then you'd still need a way to present it - e.g. a expose it as a Drupal block using chart. – artfulrobot Jan 28 at 16:03
  • Thanks! I guess we'll keep thinking... – Andyg8 May 5 at 22:21
  • Assuming that there are Activities associated with the Campaigns, you can create a view of Activities associated with the Campaigns, and aggregate by Campaign and time period, I believe. – Joe McLaughlin May 7 at 18:39

Your Answer

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

Browse other questions tagged or ask your own question.