Using fixed values for weekdays as columns

Question

Sample Data:

What I want?

Build a single combo bar chart representing the number of orders booked, shipped, and delivered on a given day of the week (Sunday through Saturday). For ex: If August 1 was a Monday: Booked-4, Shipped - 2, Delivered - 1 should be its three columns and so on.

What I did?

Used DATEDIFF and time based filters to count the distinct orders. 

Issues faced: The issue that I am having is that I cannot use WEEKDAY function corresponding to any particular date i.e. Booked, Shipped, Delivered as it messes up the count. 

I want to use fixed values for weekdays as columns. Is it possible? 

Answer 1

You can PIVOT it in the data window so all the dates are in one column.  Once you are done, it would be simple to create your desired visualization.