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
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.