Inventory Quantity Type Breakdown Metric
Essential knowledge
Intended Audience:
Business User
Author:
Movyn John
Changed on:
26 Nov 2025
Overview
Learn about the Inventory Quantity Type Breakdown Metric in Fluent Analytics
Key points
- Different transaction types reflect different inventory activities (sales reduce inventory, returns increase it, corrections adjust it)
- Type distribution changes over time based on business cycles and operational efficiency
- High correction volumes may indicate inventory accuracy issues
- Reserved quantities show demand pipeline but aren't yet fulfilled
What it measures
Breakdown of total on-hand inventory by inventory quantity transaction types (sale, reserved, correction, returned, etc.).
When to use this metric
- Understand inventory movement patterns and transaction composition
- Analyze the balance between different inventory transaction types
- Track how inventory is being consumed, reserved, adjusted, or returned
- Monitor operational patterns in inventory management
How to interpret
- Good performance: Transaction type distribution aligns with business operations and expectations
- Potential issues: Unexpectedly high correction or returned types may indicate operational problems
- Benchmark guidance: Distribution patterns vary by business model; focus on trends rather than absolute percentages
Technical details
Formula:
SUM(inventoryQuantity.qty where inventoryQuantity.status = {STATUS_ACTIVE})
grouped by inventoryQuantity.type as of current timestamp
Configuration:
- STATUS_ACTIVE: Status definitions for inventory quantities (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_position.product_ref`: Filters the metric to inventory positions for the selected product
