2 Replies Latest reply on Aug 29, 2018 3:27 AM by Tushar More

    New user and Returning user logic

    marcus.yip.1

      Hi guys! Hope everyone is doing ok.

      I have a question if tableau is able to look at the records prior to the date selected to determine if the record is a "new" one or a "returning" one.

       

      This is my raw data

       

      and my result should be like this...

       

      Have tried using lookup but i couldn't get the result i wanted.

      IF LOOKUP(ATTR([Unique UserID]),-1) = ATTR([Unique UserID]) THEN "Returning User"

      else "New user"

      END

       

      Hope u experts can help me out on this! Thank you