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: [图片] tknospdr: Can you create a selection field to narrow down category/subcategory. [图片] 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 this: -…

带日期和标签参数的已解决和未解决的主题统计

社区数据与报告

tknospdr (David Muszynski) 2025 年9 月 19 日 20:22 5

太棒了，谢谢！看起来很棒。

话题	回复	浏览量
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting solved , sql-query	242	2023 年4 月 22 日
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	417	2024 年4 月 3 日
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	213	2018 年2 月 12 日
Topics solved by staff (lists topics) Data & reporting solved , sql-query	215	2018 年2 月 12 日
Top 50 active topics (and their associated categories) Data & reporting sql-query	186	2018 年2 月 12 日

带日期和标签参数的已解决和未解决的主题统计

相关话题