ordered vs delivered
1 Topic
Monthly Orders received vs orders delivered
Hi All, I have some data like below. I want to show a monthly comparison of number of Orders received vs orders delivered in a clustered column chart. Incident Order Date Delivery Date Order1 9/12/2018 9/13/2018 Order2 9/13/2018 Order3 9/18/2018 Order4 9/19/2018 Order5 9/20/2018 Order6 9/21/2018 Order7 9/24/2018 10/21/2018 Order8 10/5/2018 10/31/2018 Order9 10/6/2018 10/11/2018 Order10 10/8/2018 11/12/2018 Order11 10/9/2018 10/11/2018 Order12 10/9/2018 10/11/2018 Order13 10/10/2018 10/11/2018 Order14 10/10/2018 11/6/2018 Order15 10/11/2018 10/11/2018 Order16 10/12/2018 11/4/2018 Order17 10/16/2018 11/14/2018 Order18 10/17/2018 11/4/2018 Order19 10/22/2018 11/4/2018 Order20 10/24/2018 10/25/2018 My problem is which date column should i choose to create the month column to show the correct data. I am looking for something like below which i can then represent in a clustered column chart however. At this moment if i create month from either of the dates then the data will be incorrect. I am already using the date table and using the month column from date table itself. Month Ordered Delivered Sep-18 7 1 Oct-18 13 8 Nov-18 6 Total 20 15 Please help.Solved5.6KViews0likes11Comments