5 Replies Latest reply on Oct 25, 2016 3:12 AM by Prasanna Selvaraju

    To find New Customers Need Help in Logic / Calculation

    Prasanna Selvaraju

      HI Tableau Guys,

       

      Greetings ,

       

      Suppose I am looking to find newly logged in user in my website with my data like below :

       

      App_ID                                     ,  Device_ID                                ,  Created_At ,  Duration     ,  Page  , Hits  , Status

      57f3ad53c627b903740006b0    57f3ad53c627b903740006af     10/11/2016       45006.001     4         9EFD  Open *********

      57f3ad53c627b903751116b0    57f3ad53c627b903740006af     10/11/2016       45006.001     4         9EFD  Open *********

      57f3ad53c627b903740006b0    57f3ad53c627b903740006af     10/11/2016       45006.001     4         9EFD  Open

      57f3ad53c627b903734534b0    57f3ad53c627b903740006af     10/11/2016       45006.001     4         9EFD  Open

      57f3ad53c627b903740006b0    57f3ad53c627b903740006af     10/11/2016       45006.001     4         9EFD  Open

      57f3ad53c627b903740006b0    57f3ad53c627b903740006af     05/15/2016       45006.001     4         9EFD  Open  *********

       

      Example : When same APP ID is coming repeatedly - OLD USER   / Newly Arriving APP ID should be termed as NEW USER

       

      If we have seen the pair before, it's a returning user.

      If we have not seen the pair before, it's a net new user.


      Thank you !