Thanks @simon - these are excellent!
I was initially confused by having the start_date and end_date parameters still required when selecting an interval, and vice versa - now I see that it returns results per X interval, within the date range specified. That’s really handy for quickly looking at monthly changes across a year, or similar scenarios.
Category and subcategory inclusion are great - I track activity in different parts of my community, so it’s very handy to be able to quickly look at how an entire category + subcategories are performing.
Is there a simple way to modify these queries to display the subcategory results in a comma-separated list?
e.g. Posts made during the interval in category 1 (10 posts), 2 (20 posts) & 3 (30 posts).
Adding the category_ids 1,2,3 to the query returns a total (60 posts). I’d love to have a method for returning 10,20,30. That would allow for side-by-side comparisons between categories.