Table analytics: Time based graph SUM() between dates?

We have a Tulip app that tracks inventory in a table. We have a check-in and check-out date and I’d like to have an analytic that shows the “inventory” over time.

For this I would need to know for each column (be it day, week, etc) is the check-in day before that, and if it has been checked-out, is it after after it.

Is this possible?