• ThomasRushton - Thursday, October 26, 2017 8:02 AM

    I thought you were looking for records where the hour was between 06:00 & 18:00, but your query says between 08:00 & 14:00...

    Thomas, I changed it around just testing... Honestly I was just using 06:00 and 18:00 as a baseline, but even if I sent the time to 11:00 & 12:00 it still shows the same percentage of usage at it does for a 24 hour day, so I know that data is incorrect it should be much less for a 1 hour window.