I would like to compare how many topics went unanswered in July 2018 versus how many went unanswered in July 2019.
Solved! Go to Solution.
@NicolaC
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
Thanks VikasB.
We only have Studio on staging. Is there any way to do this on the live site?
Thanks
@NicolaC
You can use the below URL to run it for production. You need to replace the base URL with your community base URL
Thank you!! So helpful.
Hi @VikasB
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?
@PAULEM
By default, API returns 25 results. You can pass a specific limit up to 1000 to get more results.
Welcome to the Technology board!
Curious about our platform? Looking to connect on social technology? You've come to the right place!