I suspect the reason you had the older, unchanging data prior to 6 PM in the report is that the time period type selected is "Previous" which will be distinct by "Past" by aligning to the previous period boundary (so, midnight for days, changes the end time) before subtracting the period to get the start time.