4 Replies Latest reply on Feb 8, 2019 6:20 AM by Kyle White

    Display Users Where No Data Entered for Given Day

    Kyle White

      Hi all,

       

      We need to track days where users may not be entering the hours they are spending working on cases. The custom query is filtered to start on 1/9/19 which is when we started our new hours tracking system. If a user has not entered time for any date yet there is currently a separate column for NULL and when the "NULL" date is filtered out the users are removed from the table. Instead we want the nulls to just still be applied to each date of the year as the rest of the table indicates. We would like to be able to filter to a certain date and see the list of users who did not enter hours for that day.

       

      Hope this all makes sense!

       

      Thanks,

      Kyle