Total On Hand Metric
Essential knowledge
Intended Audience:
Business User
Author:
Movyn John
Changed on:
9 Dec 2025
Overview
Learn about the Total On Hand Metric in Fluent Analytics
Key points
- Represents total investment in inventory assets
- Includes all inventory regardless of availability for sale
- Seasonal variations are normal for many businesses
What it measures
Current total physical on hand inventory for active inventory positions for the selected inventory catalog.
When to use this metric
- Monitor overall inventory investment levels
- Assess inventory turns and efficiency
- Plan purchasing and replenishment activities
- Evaluate inventory management performance
How to interpret
- Good performance: Inventory levels support sales targets without excess
- Potential issues: Too high indicates excess investment; too low risks stockouts
- Benchmark guidance: Optimal levels vary by industry and business model
Technical details
Formula:
SUM(inventoryPosition.onHand) where inventoryPosition.status = {STATUS_ACTIVE} as of current timestamp
Reference Filter Parameters:
`inventory_catalogue.ref`: Filters the metric to inventory for the selected inventory catalogue`inventory_position.status`: {STATUS_ACTIVE} - Status definitions for active inventory positions (default: ACTIVE)`location.ref`: Filters the metric to inventory positions for the selected location`product.ref`: Filters the metric to inventory positions for the selected product`retailer.ref`: Filters the metric to inventory positions from the selected retailer
