I have some questions:
You track per hour but when do you need to load this info? Can be next day morning? Where do you store this info?
I don't know your info and your issues, but my initial suggestion would be load all by the end of the day.
Give us more details.
many thanks for your reply.
The data looks as follows
Time Visitor Date
0000AM 0 010616
0300PM 5 010616
0400PM 6 010616
I would like to sum up all visitors per day in a calculated field.
I could not see a link/ reference related to your response.