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 日午後 8: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 日

解決済み・未解決トピック統計 日付とタグのパラメータ付き

関連トピック

解決済み・未解決トピック統計日付とタグのパラメータ付き