I'm not entirely sure I understand what you're trying to achieve, but I attached a workbook using your sample data. There is one calculated field "Days til fulfillment" and a combo chart showing the days til fulfillment of individual orders (blue circles) and the average days til fulfillment (orange line), plotted over time.
Let me know if that helps!
FulfillmentRates.twbx.zip 16.9 KB
Thanks for responding, Matt. I was unclear a bit of how I envisioned this to be.
Essentially, here's the question I'm trying to find an answer for:
For orders I've received, what does my fulfillment rate look like X amount of days from the order date. I'm thinking that my Rows will contain a Fulfillment Rate and my Columns will have Days from Order Range (likely 0 through 10). My Fulfillment Rate is then plotted over time using the Days from Order Range to see how it trends.
For example, I received 10 orders on 1/5. On 0 day(s) from Order Date, 3 orders were fulfilled. My Fulfillment Rate is therefore 30% on 0 day(s). On 1 day(s) from Order Date, cumulative 4 orders were fulfilled against the 10 orders. My FR% is now 40%. On 2 day(s) from Order Date, 6 fulfilled orders cumulative. My FR% is now 60%.
My Fulfillment Rate is 70%. From here, I can analyze how quickly I reach that 70% fulfillment Rate.
I hope this makes sense.