This Data Explorer report provides a comprehensive analysis of solved and unsolved topics on a site, within a specified date range, and optionally filtered by a specific tag. :discourse: This report requires the Discourse Solved plugin to be enabled. This report is particularly useful for admini…

Another awesome query, and another request from me. :slight_smile: Can you create a selection field to narrow down category/subcategory. I’d love to be able to run this report on just my tickets category.

Also, I found an odd edge case. You may or may not be able to account for it but no harm in asking. I have a topic that I created a reply to and marked it as a solution the day after it was posted. Then another tech gave a different answer and marked that one as the solution about 10 days later. T…

Hi @tknospdr , To answer both your questions here: [image] tknospdr: Can you create a selection field to narrow down category/subcategory. [image] tknospdr: The report shows time to solution as 1 day but total time without solution as 10 days. You can use the below query to address th…

Solved and Unsolved Topic Stats with Date and Tag Parameters

Community Building Data & reporting

tknospdr (David Muszynski) September 19, 2025, 8:22pm 5

Awesome, thanks! Looks great.

Topic	Replies	Views
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting solved , sql-query	242	April 22, 2023
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	418	April 3, 2024
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	213	February 12, 2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	215	February 12, 2018
Top 50 active topics (and their associated categories) Data & reporting sql-query	186	February 12, 2018

Solved and Unsolved Topic Stats with Date and Tag Parameters

Related topics