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.
- 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
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