I am trying to understand how to calculate the number of orders per restaurant per hour per weekday with my data.
I created 2 calculated fields to have weekdays and order times available.
However Im not sure of the accuracy of what I did and also some hours are missing where i am sure we are getting orders. (from 8-10pm)
Here's the viz in tableau public: Tableau Public
Thanks in advance.
I will suggest to use [Date] as portion in your calculation as shown below rather than using order time
Hope this makes sense.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...