4 Replies Latest reply on Sep 12, 2018 2:53 AM by Orlin Vladikov

    Counting the number of days a user has logged in in a Month

    Orlin Vladikov

      Hi team,

       

      Below is a sample of my data. I am trying to figure out the number of days that a user has logged in into the system within a given month.

       

      UserSessionLogin Time
      123abc

      8/03/2018 10:00:21 AM

      345def8/12/2018 12:20:00 PM
      345efg8/21/2018 8:36:21 PM
      345ghi8/21/2018 9:36:21 PM

       

      So, essentially the expected result for August is:

      User 123 logged in only on 1 day

      User 345 logged in on 2 days

       

      Any help will be greatly appreciated! Thanks!