0 Replies Latest reply on Jun 20, 2013 6:40 AM by Jim Stanley

    affinity groups

    Jim Stanley

      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

      etc.

       

      I think this is probably super simple but I can't figure it out.

       

      Thanks in advance for assistance!

      --Jim