If this is not the appropriate forum for this question, I apologize...
I have a requirement to analyze turnaround times in business days for various steps in a pipeline process. e.g., mail received to order entered, order entered to invoice, invoice to invoice paid, invoice paid to shipment.
I have a date dimension table that allows me to easily identify business days. My questions involve which ones to include. The "finger on the calendar" algorithm (point to the first day of your interval, move to the next day and count 1, etc...) leads to the rule that you don't include the beginning day of your step interval, but you do include the end day.
Would you include Monday in your count, if, say, mail was stamped as received on Saturday (although not a business day from the point of view of your customers)? Would you include the day your product shipped?
Are there more or less objective rules in current use?
I have a requirement to analyze turnaround times in business days for various steps in a pipeline process. e.g., mail received to order entered, order entered to invoice, invoice to invoice paid, invoice paid to shipment.
I have a date dimension table that allows me to easily identify business days. My questions involve which ones to include. The "finger on the calendar" algorithm (point to the first day of your interval, move to the next day and count 1, etc...) leads to the rule that you don't include the beginning day of your step interval, but you do include the end day.
Would you include Monday in your count, if, say, mail was stamped as received on Saturday (although not a business day from the point of view of your customers)? Would you include the day your product shipped?
Are there more or less objective rules in current use?