The below queries can help you to get the topics count which were posted in a specific month but not resolved yet.
For July 2019
For July 2018
You can run it you have studio/admin access.
Studio > API Browser
Here is the screenshot for your reference https://prnt.sc/px8v6p
We only have Studio on staging. Is there any way to do this on the live site?
You can use the below URL to run it for production. You need to replace the base URL with your community base URL
I have tried this and it works a treat - thanks for the tip! When I "select * from..." I get a size of 25 but when I changed the query to "select count(*) from..." I get a count of 969. Do you know why this is?
By default, API returns 25 results. You can pass a specific limit up to 1000 to get more results.