Automatic Group vs Dashboard

Product Support

AI-generated summary

Automatic Group vs Dashboard: Trust Level User Counts

A discrepancy was reported between the user counts in the Groups section and the Users Per Trust Level numbers in the dashboard. joffreyjaffeux clarified that the dashboard numbers represent “real users” with a specific trust level, whereas the Groups section shows cumulative presence in a group, including all users except two. This means that even users with higher trust levels are included in the lower trust level groups. joffreyjaffeux provided code examples to illustrate the difference, which was acknowledged and appreciated by the original poster outofthebox.

1

Hi,

On my Discourse installation, there is a large gap between the number of users in the various trust_level groups in the Groups section and the Users Per Trust Level numbers in the new dashboard. I’m wondering if this is a general bug?

2

Hi @outofthebox,

Thanks for reaching us about this. I agree it’s kind of ambiguous as the numbers we are showing on the Dashboard are what we call “real users” and is the count of users with this exact “trust_level” on the “users” table.

On the other hand, the groups pages is showing your presence in a group. And basically this is cumulative. Everyone but two users should be in trust_level_0 group even if you are trust_level=4 in “users” table.

Some code to show this:

[22] pry(main)> User.all.count
   (15.9ms)  SELECT COUNT(*) FROM "users"
=> 35956
[23] pry(main)> User.where(trust_level: 0).count
   (17.8ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 0
=> 21028
[24] pry(main)> User.where(trust_level: 1).count
   (18.2ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 1
=> 13180
[25] pry(main)> User.where(trust_level: 2).count
   (17.1ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 2
=> 1685
[26] pry(main)> User.where(trust_level: 3).count
   (16.0ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 3
=> 37
[27] pry(main)> User.where(trust_level: 4).count
   (16.1ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 4
=> 26
[29] pry(main)> 21028+13180+1685+37+26
=> 35956

# 10 is group_id for trust_level_0 group
[30] pry(main)> GroupUser.where(group_id: 10).count
   (22.4ms)  SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 10
=> 35954
3

That makes complete sense! Thanks for the insightful clarification!