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 t…

Статистика решенных и нерешенных тем с параметрами даты и тега

Создание сообщества Данные и отчетность

tknospdr (David Muszynski) 19.Сентябрь.2025 20:22:12 5

Отлично, спасибо! Выглядит здорово.

Тема	Ответов	Просм.
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting solved , sql-query	242	22.04.2023
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	417	03.04.2024
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	213	12.02.2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	215	12.02.2018
Top 50 active topics (and their associated categories) Data & reporting sql-query	186	12.02.2018

Статистика решенных и нерешенных тем с параметрами даты и тега

Связанные темы