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) 9월 19, 2025, 8:22오후 5

완벽하네요, 감사합니다! 정말 멋져 보입니다.

글	댓글	조회수
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting solved , sql-query	242	4월 22, 2023
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	417	4월 3, 2024
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	213	2월 12, 2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	214	2월 12, 2018
Top 50 active topics (and their associated categories) Data & reporting sql-query	186	2월 12, 2018

날짜 및 태그 파라미터가 포함된 해결/미해결 주제 통계

Related topics