I run an online store and am trying to figure out a way of predicting stock depletion. I have all of my data for each stock sale in a Line Items table which has dates on it.
What i need is to calculate the number of items sold in the last period of time (week, month etc.) so i can then estimate when my stock will run out. My business is very seasonal (seeds) so the rates will change over the course of the year which is why i need to be able to calculate the current rate.