[imagen] User posts by email domain over last 7 days Data & reporting I think it actually gives inflated numbers due to the group joins (also, everyone is part of an automatic group for their trust level, so there’s a bit of inconsistency there). I think we can…

I think having the results per user rather than grouped by email domain makes this a slightly different query. Let’s split this off into its own topic. :+1:

I think something like this should do it: -- [params] -- string :interval = 7 days WITH post_data AS ( SELECT p.user_id, COUNT(p.id) AS total_posts, COUNT(p.id) FILTER (WHERE p.post_number = 1 AND t.archetype = 'regular') AS topics, COUNT(p.id) FILTER (WHERE p.…

This is perfect!! Thank you so very much.

Estadísticas del usuario más correo electrónico

Comunidad Datos e informes

JammyDodger 23 Julio, 2024 09:48 2

Creo que tener los resultados por usuario en lugar de agrupados por dominio de correo electrónico hace que esta sea una consulta ligeramente diferente. Separemos esto en su propio tema.

Tema		Respuestas	Vistas
User posts by email domain over last 7 days Data & reporting sql-query	3	343	19 Abril 2024
User participation Data & reporting sql-query	0	220	17 Noviembre 2017
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	228	31 Diciembre 2019
Posts Read (Daily) Data & reporting sql-query	0	155	1 Mayo 2016
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	25 Noviembre 2024

Estadísticas del usuario más correo electrónico

Temas relacionados