Hi - I have a really simple question (hopefully) about how to write a custom query to bin members into different types of affinity groups (freqency of use). I've attached sample data that shows user ID and the ID of a location where they have activity, and date and time.
I'd like to see this in standard groupings like:
X% of users have activity 1 time per period
X% of users have activity 2 times per period
X% of users have activity 3 times per period
I think this is probably super simple but I can't figure it out.