This is an SQL version of the Dashboard Report for Posts. This report provides a daily count of posts created within a specified date range. It is designed to track the activity in regular topics, excluding posts from private messages and other special archetypes. --[params] -- date :start_date --…

This is great. Would there be a way to be able to define the category/subcategory at run time as the date? And bonus, can we either list the results by user, or define the user as well? What I’m trying to do is see how many posts are made during (range) in my support tickets areas by my support s…

[image] tknospdr: Would there be a way to be able to define the category/subcategory at run time as the date? And bonus, can we either list the results by user, or define the user as well? Yes, you can use the following query for this: --[params] -- date :start_date -- date :end_date -- nul…

Rapport du tableau de bord - Publications

Communauté Données et rapports

tknospdr (David Muszynski) Septembre 9, 2025, 8:03 4

Merci, c’est d’une grande aide !

Sujet		Réponses	Vues
Aggregate dashboard report data by time interval Data & reporting sql-query	4	1233	Septembre 24, 2022
Dashboard Report - Topics Data & reporting sql-query , dashboard-reports , dashboard-sql	0	467	Décembre 12, 2023
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	2	290	Janvier 31, 2025
Top X posters in a given timeframe Data & reporting sql-query	3	273	Mai 28, 2024
Posts created for period Data & reporting sql-query	0	222	Septembre 14, 2016

Rapport du tableau de bord - Publications

Sujets connexes