-- [params]
-- date :start_date = 17 aug 2026
-- date :end_date = 17 sep 2026
SELECT
ar.date,
SUM(
CASE
WHEN ar.req_type = 15 THEN ar.count
ELSE 0
END
) AS page_views_logged_in,
SUM(
CASE
WHEN ar.req_type = 13 THEN ar.count
ELSE 0
END
) AS page_views_anonymous
FROM application_requests ar
WHERE ar.date >= :start_date
AND ar.date <= :end_date
AND ar.req_type IN (13, 15)
GROUP BY ar.date
ORDER BY ar.date ASC
What happened to the other page views on my dashboard?
Edit: Had a look at the pageviews in the past months
Thank you for reporting this. We are in transition on how browser pageviews are measured. My theory is that 6th of July you had a new dashboard enabled for a moment (with the new tracking method enabled), and you disabled it. It is totally fine, but the graph should move back to use numbers from the old tracking.