2 Replies Latest reply on Nov 2, 2018 9:33 PM by Jennifer VonHagel


    Bhumika Bhandari

      Hi Everyone,


      To generate this report I have:

      one table with User information and another one with User_Event info. In User_Event table, I have event_id for all the activities like login, signup, logout etc.


      What I want to do it:

      Find users who logged in and minus that count with the signup ones.



      event_id for login: 80

      event_id for signup: 81

      event_id for logout: 82


      How am I suppose to get user count for event 80 and 81 and get a difference?


      Let me know if you need any other information.





        • 1. Re: Calculation
          Cathy Bridges

          Seems like something like this should work:

          Gantt Chart, Time between end and start

          • 2. Re: Calculation
            Jennifer VonHagel

            Hi Bhumika,


            It would be great if you could share some sample or dummy data in a .twbx file.  I can give you a few calculation suggestions (below), but I have a history in web analytics and am aware that other elements might come into play; it would be helpful to have a sample of your data structure.


            Users who Login  //Note: the ELSE NULL is implied - you don't have to have it

            COUNTD(IF [event_id] = 80 THEN [user_id] ELSE NULL END)


            Users who Signup   //Note: the ELSE NULL is implied - you don't have to have it

            COUNTD(IF [event_id] = 81 THEN [user_id] END)


            Users Not Signed Up

            [Users who Login] - [Users who Signup] users_not_converted


            Hope this helps!