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

Gelöste und ungelöste Themenstatistiken mit Datums- und Tag-Parametern

Gemeinschaft Daten & Berichterstattung

tknospdr (David Muszynski) 12. September 2025 um 13:41 2

Eine weitere tolle Anfrage und eine weitere Bitte von mir.

Können Sie ein Auswahlfeld erstellen, um Kategorie/Unterkategorie einzugrenzen?
Ich würde diesen Bericht gerne nur für meine Ticketkategorie ausführen können.

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

Gelöste und ungelöste Themenstatistiken mit Datums- und Tag-Parametern

Verwandte Themen