0 Replies Latest reply on Nov 15, 2013 9:24 AM by Jason Scott

    How to find specific items in a range

    Jason Scott

      Hello All,

       

      So i'm trying to figure something out here is tableau.  I have a data set with a bunch of users who when into different modes in a software app on a specific day.  What i'm trying to figure out is how to determine when a user went into multiple game modes in a day how many of them went into say mode 1 and mode 3

       

      Here is a basic example of the data

      UserMode
      1mode 1
      1mode 3
      1mode 2
      2mode 1
      2mode 2
      3mode 1
      3mode 2
      3mode 3
      3mode 6
      4mode 1

       

      So looking at the example above I would want a results like this

      Mode 1User Count
      Mode 1 and 31
      Mode 1 and 23

       

      I have been trying to figure out how to do this grouping since i cannot group it as a mode can be in different combinations.

       

      Any help would greatly be appreciated.

       

      Thanks

      Jason