1 Reply Latest reply on Aug 30, 2017 6:48 AM by Simon Runc

    adding connection between observations based on stings

    Mads Plesner

      Hi Everybody

       

      I'm working with webdata and I need to connect sessions and events with the same person and add a column with the name for each. The logic is whosen in the picture below.

       

      I need to calculate the time one person spends on the webpage - a simple calculation max(timestamp)-min(timestamp) is god enough, but how do I fixe the calculation on users, when many fields are empty?

      example fixed on users.JPG