Using restaurant open hours data in time series plots

You can do similar to Fiscal Calendar implementation. You need to build a table that covers all days and hours of restaurant.

Calendar Day | Calendar Time | Restaurant Day | Restaurant Time | Index

FRI | 2PM | FRI | 2 PM | 2

...

FRI | 10PM | FRI | 10 PM | 10

FRI | 11PM | FRI | 11 PM | 11

SAT | 12AM | FRI | 12 AM | 90

SAT | 1AM | FRI | 1 AM | 91

SAT | 2AM | FRI | 2 AM | 92

and for the Restaurant time, set the sort by columns as "Index"

and hide the index column from reporting "hide in report view"

and use the Restaurant Day, Restaurant time for your reporting.

Hope this helps~!