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?