This is an SQL version of the Dashboard Report for Consolidated Pageviews. This SQL report provides a daily count of pageviews from logged in users, anonymous users, and crawlers on a Discourse site. -- [params] -- date :start_date -- date :end_date SELECT ar.date::date AS "date", SUM(ar.…

Dashboard-Bericht - Konsolidierte Seitenaufrufe

tyler.lamparter (Tyler Lamparter) 24. März 2025 um 23:37 4

Thanks Sara, the query in the Dashboard Report - Site Traffic topic answers my question around using 13 and 15 and also why 13 + 14 != 8.

1 „Gefällt mir“

Thema		Antworten	Aufrufe
Dashboard Report - Consolidated Pageviews with Browser Detection Data & reporting dashboard-reports , dashboard-sql , sql-query	5	269	21. Juni 2024
Dashboard Report - Web Crawler Pageviews Data & reporting dashboard-reports , sql-query , dashboard-sql	0	328	8. Februar 2024
Dashboard Report - Site Traffic Data & reporting dashboard-reports , dashboard-sql , sql-query	0	104	24. März 2025
Dashboard Report - Anonymous Data & reporting dashboard-reports , sql-query , dashboard-sql	9	477	21. Dezember 2023
Dashboard Report - Logged In Data & reporting dashboard-reports , sql-query , dashboard-sql	0	348	10. Januar 2024