1 Reply Latest reply on Aug 13, 2015 3:02 PM by Patrick A Van Der Hyde

    how to identify distinct count between day before yesterday 7 pm to yesterday 7 pm

    Rahul Sahil

      Hi,

       

      I want a distinct count of employees logged in between  day before yesterday 10 pm to yesterday 10 pm and I have two columns for date logged date (2015-06-21,2015-06-22,etc ) and logged time (20:00:00,18:05:00,17:06:07 etc) from which data is been populated.

       

       

       

       

      Report Ex:

       

                                                2015-06-21(7pm) to 2015-06-22  (7 pm)

       

      Countd[employees]                                    20

       

      Want to know how to combine two fields data and get a count between the specific time of Day before yesterday to Yesterday

       

       

      Thanks,

      Rahul