I'm having a go at this and am looking at your data. Where you for Null values for 'Completion Date' does that mean that the order is still in progress? Even when the required date is way overshot?
I'm thinking about creating an order status so where we have Completion Date is null and the required date < today's date then the order is 'Overdue' and were required date is > today's date then the order is 'In progress'.
Is that how your data should be interpreted?
I have attached a sample workbook using your data. The first hurdle was stitching together the date and time columns into a single calculated field. Next I followed the steps in the following KB:
Let me know how it looks. Thanks!
pie charts.twbx 76.2 KB