Discussions
Orders that COULD HAVE shipped - Per day
I want to make a saved search that shows the number of packages that COULD have shipped per day, vs the number of packages that DID ship per day. The idea being, I want to see when our volume grows large enough that it exceeds the physical abilities of our shipping team, implying that its time to add another shipping employee to the shipping staff
For example:
Date---------Eligible to Ship----Actually Shipped----%Efficiency
1/15/2013----51---------------40------------------79.4%
1/16/2013----53---------------41------------------77.4%
1/17/2013----35---------------35------------------100%
The column for "Actually Shipped" is easy...because you can just group fulfillments by date.
But, how would I count the number of orders that COULD have shipped? per day?