Question for fellow Data people here

[JammyDodger]

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

Admin dashboard report reference guide

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. Required user level: Staff Discourse contains several built-in admin dashboard Reports that can be useful for exploring stats about a community. To access these reports, you can visit discourse.example.com/admin/dashboard/reports on your site ( or click the…

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