1 of 1 people found this helpful
Do you want to see the number of records broken down by each hour or the total number of records for all of the hours between 6 am and 6pm?
If it's the first, simply place all of the hours on the view along with the Number of Records field that is automatically added to the fields. If it's the latter a calculated field similar to the following can be created:
total(sum([Number of Records]))
The above uses a table function which depending on how it is being computed and the structure of the table may give you a different outcome. The following link provide further information on table calculations:
Hope this helps!
Thanks Tracy. I am looking at a breakdown of both. I was able to get the count of total records for that timeframe. Now I am on getting a percentage from those hours to the total.
I'll look at the site you suggested to see if it can help me out with my calculations.