Total On Hand Metric
Essential knowledge
Intended Audience:
Business User
Author:
Movyn John
Changed on:
13 Nov 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
Configuration:
- STATUS_ACTIVE: Status definitions for active inventory positions (default: ACTIVE)
Reference Parameters:
`retailer.ref`: Filters the metric to inventory positions from the selected retailer`location.ref`: Filters the metric to inventory positions for the selected location`inventory_catalogue.ref`: Filters the metric to inventory for the selected inventory catalogue`product.ref`: Filters the metric to inventory positions for the selected product
