I'm building a Drupal 7 View in which I want to aggregate contribution records for the year, grouping by month. But View's native aggregation option happens after the query is generated, so it's not possible to group by MONTH(receive_date). I tried using the Views Date Format SQL module, which in theory should let me apply the group by on the query, but it doesn't seem to handle non-core-Drupal date fields.
I also explored using Views Aggregator Plus module, which does let me render a table with correct grouping. But my end goal is to display a chart (using the Charts module), so I need to be able to build the aggregate query without an alternate display format (you can't use VAP and Charts together -- they are mutually exclusive display format options).
I feel like the ability to use Views to generate aggregate stats on Civi data is probably something people are doing... but I'm getting stuck.