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


(Alessio Fattorini) #1

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


(Alessio Fattorini) #2

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


(Mittineague) #3

Is this close?


#4

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


(Alessio Fattorini) #5

Yes man, how can I filter for group_id?


(Mittineague) #6

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