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.