My app has a property where users can be a part of multiple teams. These teams can be joined / left fairly regularly, and I would be able to answer questions like "how many teams have more than 5 users".
How do I do this with Mixpanel? I assume this is a fairly basic question, so feel free to point me at whatever documentation exists (I tried searching for it, but didn't find anything useful).
I looked into Group analytics (https://help.mixpanel.com/hc/en-us/articles/360025333632-Group-Analytics); however, based on the comparison of group_id to distinct_id, it doesn't seem like a user can be a part of multiple groups in the same category (which doesn't work as a user can be a part of many teams).