How can I count posts in last month by a specific group of users?

[alefattorini (Alessio Fattorini)]

Do you have any query for Data explorer?
I need to calculate the impact of my ambassador group

[alefattorini (Alessio Fattorini)]

Can I bump it again? I need that data for each member. Last month or a specific range of time

[Mittineague]

Is this close?

What cool data explorer queries have you come up with?

Posts created for period Got what I need (thanks @meglio) so updating this for future posterity. -- [params] -- date :date_from -- date :date_to -- int :min_posts = 1 WITH user_activity AS ( SELECT p.user_id, count (p.id) as posts_count FROM posts p LEFT JOIN topics t ON t.id = p.topic_id WHERE p.created_at::date BETWEEN :date_from::date AND :date_to::date AND t.deleted_at IS NULL AND t.visible = TRUE AND t.closed = FALSE AND t.archived = FALSE…

[HAWK]

That one doesn’t allow you to specify the group id as a parameter

[alefattorini (Alessio Fattorini)]

Yes man, how can I filter for group_id?

[Mittineague]

I think a JOIN with the group_users table ON user_id WHERE group_id should do it.

group_users
id    serial    primary key 
group_id    integer    fkey groups 
user_id    integer    fkey users 
created_at    timestamp 
updated_at    timestamp 
owner    boolean    default false 
notification_level    integer    default 2