Yeah, in looking a bit more at these, I think there is still going to be an issue answering the question “how many items did we have on the shelves on this day in the past”?
I don’t think that information is tracked anywhere, so it is going to require a lot of calculating. Looking at the creation date of items and then combing the transactionsdetails for all the deleted items from the current date.
If you’re on your own system it may be a candidate for exporting nightly or creating your own custom aggregates table to make this easier to track going forward.