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: SELECT u.id, b.name, u.created_at, ub.granted_at, to_char(date_trunc('month', ub.granted_at), 'YYYY Mon') from badges b join user_badges ub on b.id = ub.badge_id join users u on u.id = ub.user_id where b.name 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)

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

Two New Users of the Month?

Product Support

jericson (Jon Ericson) October 24, 2022, 6:32pm 3

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?

Topic		Replies	Views
New User of the Month badge awarded before registraton date Bug	2	843	July 13, 2020
New User of the month is..wrong? Product Support	7	589	August 2, 2023
"New User of the Month" badge doesn't appear to be monthly? Bug	13	1474	May 26, 2017
New user of the month: wrong month, not localized Translations	11	3048	January 28, 2020
How does user of the month or rookie of the month works? Product Support	8	716	July 22, 2019

Two New Users of the Month?

Related topics