Two New Users of the Month?

I’m pulling together a “state of the community” report and I thought it would be fun to list the “New User of the Month” badges. Here’s my query:

       to_char(date_trunc('month', ub.granted_at), 'YYYY Mon')
from badges b
     join user_badges ub on = ub.badge_id
     join users u on = ub.user_id
where like '%Month%'
order by ub.granted_at desc

The results are odd:

id name created_at granted_at to_char
1613225 New User of the Month 2022-09-10T14:27:10.130Z 2022-09-30T23:59:59.999Z 2022 Sep
1613874 New User of the Month 2022-09-18T21:57:19.944Z 2022-09-30T23:59:59.999Z 2022 Sep
1611913 New User of the Month 2022-08-23T11:30:12.639Z 2022-08-31T23:59:59.999Z 2022 Aug
1610355 New User of the Month 2022-07-30T20:12:00.342Z 2022-07-31T23:59:59.999Z 2022 Jul
1609245 New User of the Month 2022-07-12T16:11:48.272Z 2022-07-31T23:59:59.999Z 2022 Jul
1607137 New User of the Month 2022-06-09T23:37:46.687Z 2022-06-30T23:59:59.999Z 2022 Jun
1607399 New User of the Month 2022-06-14T14:16:14.247Z 2022-06-30T23:59:59.999Z 2022 Jun

More often than not, there are 2 New User of the Month badges awarded. Note that they are granted at the same time. (It’s also a bit strange that a user might be awarded the badge after a day (see the July badge), but it’s certainly possible for someone to start off hyper active.)

I don’t mind recognizing extra people for good contributions, but I’d like to explain what’s going on when I write this up. It’s also possible we have something screwed up in our configuration.

It should be given to two users: :+1:

This badge is granted to congratulate two new users each month for their excellent overall contributions, as measured by how often their posts were liked, and by whom

(from the Badge description)


Gawk! I need to stop complaining about users who don’t read. That said, it’s odd that there’s just one for other months. Would that be because there aren’t enough new users who meet the criteria?


My initial thought is that it may be a month where the badge was granted to two, but one user was deleted afterwards?


This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.