7 Replies Latest reply on Feb 4, 2016 1:01 PM by Andrew Macey

    Find the hour in which users log in

    Lazy Rambler

      I have been trying to create an admin view. I need to find the hour of the day where most of the people login. I was thinking of a histogram and the bins would be the hour of the day and the length of the bar is the number of users.

       

      Can anyone help me with the tables I would need in the postgres? I see that the users table only has the last login time, which is not that useful.