Custom Report: Check-Ins by Type / Hour / Day of Week

Report Description:
Generates a report showing the number of daily check-ins within a specified date range, broken down by type (Member, Punch Card, or Guest), hour of the day, and day of week.


Columns Displayed
:

  • Type of Check-In (Guest, Member, Punch Card, Total)
  • Hour of Day
  • Total check-ins for that Hour of Day/Type for all days of the week
  • For each day of week: Number of Check-Ins for that Hour of Day/Type

 

check_ins_by_type_hour.png

 

Download the SQL code as a .txt file 

 


Disclaimer: Custom SQL reports can be used or modified by RGP customers at their own discretion. However, due to the custom nature of each report and the varying size of a customer's database, some reports may be slow to run (or may not run at all).  All support and/or modifications requested of these public, custom reports will follow the standard Custom SQL Report fee structure.0

Please also see: Adding Custom SQL Reports


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.