Perfect Order Metrics

I'm trying to create a dashboard reflecting if an order was shipped on time and in full.

I'm trying to figure out a way to group my data by order number (some orders have multiple lines) and then identify which of those orders have a fulfillment date for each of the lines within each order.

I feel that I need to find away to group the orders check every line and then output a binary option into a new column to identify if the whole order has been filled before I can calculate the percent of orders filled on time.

Any help would be greatly appreciated!