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

    New user and Returning user logic


      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"



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