2 Replies Latest reply on Jul 17, 2018 3:41 AM by Andrew Flynn

    Identify users who performed certain actions - dynamic sets based on dimension values?

    Andrew Flynn

      Hi,

      I have been trying to analyse user actions for a certain application.  The data set is rather complex so I have provided a simplified table here to illustrate:

      I have a dimension 'UserId' which is continuously incrementing; and another dimension 'Action Name', which has two values, Action 1 and Action 2.

      Some users have performed one or other of the actions and some have performed both.  For the sake of simplicity a user cannot perform the same action more than once.

       

       

      UserIdAction Name
      1Action 1
      2Action 1
      3Action 1
      4Action 1
      5Action 1
      6Action 1
      7Action 1
      2Action 2
      3Action 2
      4Action 2
      8Action 2
      9Action 2
      10Action 2
      ......
      ......

       

      As this is a live and growing dataset, I need to create sets and/or calculations which will automatically include new rows of user actions, to identify:

      - users who have performed Action 1

      - users who have performed Action 2

      - users who have performed both Action 1 and Action 2.

       

      I feel this should be really simple in Tableau but the answer is elusive!  Part of the problem seems to be the exclusivity of the Action Name as a filter on User, when used in calculations and sets, i.e. it can only return one value.

       

      Any ideas?