Create insights for number of users in some group, group by number

  • 29 September 2021
  • 0 replies

Hello! I have a question about how to create insight with group information.

In our case we have Users and a group Team. Users have a list of teams. Until here all good, I’m able to get the insight data of the number of teams per users using a custom function LEN.

The Custom formula is: LEN(.teams_ids)

My question is, how we can do a report that shows the number of teams that has 1,2,3,etc users?

My first thought was that we can do a breakdown to get the LEN of teams for users and then search if we can do some kind of group by, but I don’t see how to do it, or if this is possible.


0 replies

Be the first to reply!