# Statistiques par groupe et par niveau de confiance ?
**URL:** https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189
**Category:** Support
**Created:** [Mars 30, 2018, 12:48 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189 "2018-03-30T00:48:59Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@jonobacon](https://meta.discourse.org/u/jonobacon)
#### Post date: [Mars 30, 2018, 12:48 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/1 "2018-03-30T00:48:59Z")
Hi Everyone,
I am finding with more and more rollouts of Discourse with clients that I am wanting to track the following:
- I would like to see the existing graphs but for specific groups (the trust level groups included). I can do this for the read graphs, but not topic and post graphs.
- I would also like to be able to see a list of which people move between trust levels on a set cadence (e.g. every month).
Am I missing something, or are these statistics not currently available?
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [Mars 30, 2018, 6:59 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/2 "2018-03-30T06:59:10Z")
I’m not clear as to exactly what you’re looking for. Maybe something like this using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin?
```plaintext
WITH trust_level_one AS ( SELECT to_char(user_badges.granted_at, 'YYYY-MM') AS tl1ym
, COUNT(user_badges.user_id) as tl1uc
FROM user_badges
WHERE user_badges.badge_id IN(
SELECT id
FROM badges
WHERE badges.name LIKE 'Basic User')
GROUP BY to_char(user_badges.granted_at, 'YYYY-MM')
)
, trust_level_two AS ( SELECT to_char(user_badges.granted_at, 'YYYY-MM') AS tl2ym
, COUNT(user_badges.user_id) as tl2uc
FROM user_badges
WHERE user_badges.badge_id IN(
SELECT id
FROM badges
WHERE badges.name LIKE 'Member')
GROUP BY to_char(user_badges.granted_at, 'YYYY-MM')
)
SELECT trust_level_one.tl1ym
, trust_level_one.tl1uc
, trust_level_two.tl2uc
FROM trust_level_one
FULL JOIN trust_level_two
ON trust_level_two.tl2ym = trust_level_one.tl1ym
GROUP BY trust_level_one.tl1ym, trust_level_one.tl1uc, trust_level_two.tl2uc
ORDER BY trust_level_one.tl1ym
```
example results
| tl1ym | tl1uc | tl2uc |
| --- | --- | --- |
| 2016-02 | 11 | 6 |
| 2016-03 | 19 | 4 |
| 2016-04 | 12 | 7 |
| 2016-05 | 5 | 13 |
| 2016-06 | 1 | 1 |
| 2016-12 | 1 | NULL |
| 2017-01 | 1 | 1 |
| 2017-11 | 1 | 1 |
| 2018-01 | 2 | 1 |
---
### Author:  [@jonobacon](https://meta.discourse.org/u/jonobacon)
#### Post date: [Mars 30, 2018, 4:19 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/3 "2018-03-30T16:19:29Z")
> [@Mittineague](#):
>
> I’m not clear as to exactly what you’re looking for.
In a nutshell, there are two primary things I want to know:
- Firstly, I would like to know which users are transitioning between trust levels each month (e.g. “Foo, Bar, and Baz went from Trust Level 2 to 3 this month”). This way I can connect those people to my incentive programs.
- Secondly, I want to see the current graphs in the dashboard applied to specific groups. I can do this for user visits and new users, but I can’t see this for topics/posts and other graphs.
I just wanted to ask if there is a way to do this inside the current admin interface, or do I need a different plugin or query for this?
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [Mars 30, 2018, 5:31 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/4 "2018-03-30T17:31:26Z")
Interesting - I’ve been wanting better stats about groups as well, but different ones. Personally I’ve given up on trying to use trust levels for incentivization and have hidden them from view.
If you look in the new groups management pages you can look in the log to see who has joined groups and when. At the moment this doesn’t appear to be available for automatic groups. (cc @tgxworld)
Here’s what I’d love to see:
> [@Amount of time spent reading by Discourse groups](https://meta.discourse.org/t/amount-of-time-spent-reading-by-discourse-groups/77702):
>
> One of my favorite new discourse 1.9 features is the “time spent (time spent recently)” stat on user cards. This is super helpful for understanding whether the person I am looking at is a truly active, participating member of the community who is curious and engaged. I’d be interested in getting this information about discourse groups. Specifically, how much time have members of a particular discourse group spent collectively reading discussions? It will help to monitor the health of …
---
### Author:  [@jonobacon](https://meta.discourse.org/u/jonobacon)
#### Post date: [Mars 30, 2018, 6:07 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/5 "2018-03-30T18:07:01Z")
> [@tobiaseigen](#):
>
> Interesting - I’ve been wanting better stats about groups as well, but different ones. Personally I’ve given up on trying to use trust levels for incentivization and have hidden them from view.
Interesting. How have trust levels not worked for you for incentivization and how did you use them? If there is another topic with this, happy to read it.
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [Mars 30, 2018, 6:20 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/6 "2018-03-30T18:20:39Z")
There are a few topics about this from a few years ago. The main thing to know about trust levels is that they are mostly about privileges and powers, and admins can put a halt to automatic promotion by setting trust levels. There is also not enough transparency to the members about how they work and when people are promoted and for what reason. In my community this caused some grief among moderators who got competitive and were frustrated that they were not being promoted. Pointless, really, because they were already moderators.
So.. we just focus on badges, and metrics like time spent reading!
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [Août 1, 2020, 4:52 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/7 "2020-08-01T16:52:18Z")
---
### Author:  [@Shirly\_Nowak](https://meta.discourse.org/u/Shirly_Nowak)
#### Post date: [Octobre 25, 2022, 8:24 UTC](https://meta.discourse.org/t/statistics-per-group-and-per-trust-level/84189/8 "2022-10-25T08:24:05Z")
> [@jonobacon](#):
>
> Premièrement, j’aimerais savoir quels utilisateurs passent d’un niveau de confiance à un autre chaque mois (par exemple, « Foo, Bar et Baz sont passés du niveau de confiance 2 au niveau 3 ce mois-ci »). De cette façon, je peux connecter ces personnes à mes programmes d’incitation.
Salut @jonobacon, as-tu finalement trouvé cette fonctionnalité ? J’en aurais vraiment besoin pour ma communauté aussi, car nos programmes d’incitation sont également liés aux niveaux de confiance 🙂