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.