Hi, I’m a moderator on the Hopscotch forum, and I was wondering if we could ask for help with these Data Explorer queries:
- How many
@
mentions that groups have had in the past 365 days- sorted from lowest to highest,
- and only if the group has existed for more than 365 days (i.e. the group creation date is more than 365 days ago)
- How many
@
mentions that groups have had in the past 365 days- only if the group has less than 5 mentions in the past 365 days
- sorted from lowest to highest,
- and only if the group has existed for more than 365 days (i.e. the group creation date is more than 365 days ago)
- How many members that groups have,
- only if the group has less than 10 members
- sorted from lowest to highest
The aim is for us to work through removing inactive groups. (I would pass queries to an admin to create)
Thank you in advance,
Tracey
(I would add the tag #data-explorer but it seems like I can’t do that at the moment)