Saturday, November 12, 2016

yogi_Compute Stats For Hourly Visitor Count For WeekDays And WeekEnds

Google Spreadsheet   Post  #2083
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-12-2016
question by: Nudus:!topic/docs/bSSx7ZhOsXU;context-place=forum/docs

Trying to pull out metrics off a visitor log.

 Hey guys!

I'm trying to figure out a way to pull average visits on an hourly base - So I can tell how many people visited on average per hour for different hours.

I have the log files that our swipe card system creates , I attempted to create a Pivot Table but I cant seem to get them to display unique only.

Ideally I'd like to be able to get statistics for weekdays / weekends separately.

File link:

Would really appreciate any help, I'm at a loss here :<