Check the workbook I've attached. Was this what you were looking for?
Before you can build this visualization, you're going to have to pivot your operating hours like so:
Shoppers per Hour.twbx 17.9 KB
Thanks for your response.
The Shopper data is sourced from Salesforce and the operating hours are sourced from an Excel Spreadsheet. How would I combine these as you had in your workbook?