Question for fellow Data people here

[JammyDodger]

I’m not sure if these are helpful but there’s:

Admin Dashboard Report Reference Guide

Looking for information about the Admin Dashboard Reports? You’re in the right place! This is a reference guide for describing how the Admin Dashboard Reports function, the data they’re displaying, the corresponding Data Explorer SQL queries, and where to find the Ruby code for each report. Admin Dashboard Reports This post is a Wiki! Feel free to add information here you feel may be helpful for other admins, moderators, or developers using Discourse Reports. Dis…

Trying to understand pageviews

This thread tells me which table to look in for pageview data & how to understand it (what each request_type means). I used that to write some year-over-year reports. I was looking at them today and started wondering about the numbers versus what’s reported on the admin homepage. So I started digging in a little. Here’s what a direct DB query tells me about yesterday: [Selection_804] Versus the reporting on the admin homepage: [Selection_801] I don’t know how to map the last two counts fr…