[image] 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.

Statistiques utilisateur plus email

Communauté Données et rapports

JammyDodger Juillet 23, 2024, 9:48 2

Je pense qu’avoir les résultats par utilisateur plutôt que regroupés par domaine de messagerie rend cette requête légèrement différente. Séparons cela dans son propre sujet.

Sujet		Réponses	Vues
User posts by email domain over last 7 days Data & reporting sql-query	3	343	Avril 19, 2024
User participation Data & reporting sql-query	0	220	Novembre 17, 2017
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	228	Décembre 31, 2019
Posts Read (Daily) Data & reporting sql-query	0	155	Mai 1, 2016
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	Novembre 25, 2024

Statistiques utilisateur plus email

Sujets connexes