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     www.energyefficientbuild.com.   Nov-12-2016
question by: Nudus:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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:
https://docs.google.com/spreadsheets/d/1wzJejhfh-yL_y-rvHC_lgD8y_HR-wCZkDfwLN0d7wUw/edit?usp=sharing

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