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?
I feel like im normally pretty good at making saved searches but im stumped on this one.
Anyone have any ideas?