Does dbt support a metric like ending on hand (EOH) inventory metric?
Using a bike shop as an example, if we have 5 mountain bikes and 6 road bikes on Tuesday, and towards the end of the week, we had 3 mountain bikes and 4 road bikes, the EOH (ending on hand) inventory metric will be calculated as follows:
- “sum(# of bikes)” along the product dimension
- “last value” along the time dimension
Is there a way to define this metric? It didn’t seem like we could calculate this by just using calculation_method and time_grains.