4 Replies Latest reply on Nov 18, 2011 5:43 PM by Jeffery Webb

    calculations on joined tables - distinct rows

    Jeffery Webb

      Assume I have users in a system. I track the users that login (so I join from users to logins) and I track pages they view in a system (join from logins to pageviews). How can I build a calculation on the distinct list of logins to calculate which users have been active in the system?

       

      Right now I have an "Active Count" calculated filed: IF [status] = 'active' THEN 1 ELSE 0 END but when you add that as a measurement it counts each pageview and doesn't take into account the unique logins.

       

      Thanks for the help!