Rails & Groupdate gem to find users with more than X videos per month

211 Views Asked by At

Users in my Rails app make videos. I'm using the Groupdate gem to get the monthly active users (meaning the number of user who made more than 1 video in the month):

Video.group_by_month(:created_at).count("DISTINCT user_id")

which returns something like this:

{
 Mon, 01 Aug 2022=>116,
 Thu, 01 Sep 2022=>101,
 Sat, 01 Oct 2022=>109,
 Tue, 01 Nov 2022=>153,
 Thu, 01 Dec 2022=>104
}

Now I want to get the number of user who made more than X videos, grouped by month as before.

How do I do that?

0

There are 0 best solutions below