0 Replies Latest reply on Dec 12, 2013 10:47 AM by Ferran Pijoan

    Filters combinations to create exclusive groups

    Ferran Pijoan

      Hi!


      I am trying to filter users (customers) and be able to create groups of them depending on what platform they have used.

      An example similar to my data would be (attached file too):

       

      User      Platform              Revenue

      1             Visa                       2

      2             Visa                       4

      1             Pay Pal                 2

      2             AMEX                   3

      3             Master Card      1

      4             Visa                       2

      4             Pay Pal                 4

      1             Pay Pal                 1

       

      I would like to create groups of users that have used 2 specific platforms, or 3 specific platforms.

       

      For example, I would group the users that have used "Visa & Pay Pal" platforms. Resulting the users 1 and 4.

      Or I would group the users that have used "Visa & AMEX" platforms. Resulting just the user 2.

      Or group the users that have used "Pay Pal & AMEX & Master Card". Resulting 0 users.

      Or group the users that have used "AMEX & Master Card". Resulting 0 users.

       

      I've tried to get that using Sets and combining them, but it didn't work at all.

       

      Any ideas?

       

      Thanks in advance.