Using restaurant open hours data in time series plots

[vminvsky]

I'm creating a heatmap that looks like:

Each cell represents the sales of a restaurant on a given day, at a given hour. The issue I have is restaurants often operate past midnight, and it's still considered the same "work day". So the first two rows actually represent the sales from the previous day. 

Does anyone have any ideas how to adjust the time signature to make each column go from 2 PM to 2 AM? 

[sevenhills · Accepted solution]

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~!