Product Analytics
Analytics charts can be filtered by product and Pareto charts can group data by product. This enables product-level performance analysis.
Product Filtering
Any time-series or Pareto chart can be filtered to specific products via the product_ids configuration field. This filters which batches are included in calculations.
Affected metrics (batch-dependent):
- OEE (parts aggregation for performance and quality)
- Performance, Quality, Scrap Rate
- Batch Count, Batch Duration, Average Batch Duration
Not affected (event-based, not product-specific):
- Downtime metrics (downtime events don’t belong to products)
- Incident metrics
- MTBF, MTTR
Product Pareto Category
Setting pareto_category_metric to product groups Pareto bars by product. Each bar represents one product, with the category label showing the product family name.
This answers questions like:
- Which product has the most downtime?
- Which product has the highest batch count?
- Which product generates the most scrap?
Product-Specific Value Metrics
These Pareto value metrics use product-level data fields:
| Metric | Formula | Use Case |
|---|---|---|
production_value | SUM(good_parts x unit_value) | Revenue contribution by product or equipment |
scrap_cost | SUM(scrap_parts x unit_value) | Waste cost by product or equipment |
total_standard_hours | SUM(product.standard_hours) per batch | Labor budget allocation |
efficiency | (SUM(standard_hours) / SUM(actual_hours)) x 100 | Labor productivity comparison |
These metrics require products to have unit_value and/or standard_hours configured in Product settings.
Configuration
Product filtering is available in the chart configuration modal:
- Product selection dropdown — multi-select list of active products for the site
- Stored as
product_ids(JSONB array of UUIDs) onoee_analytics_charts - When empty (
[]), all products are included (no filtering)
See Also
- Analytics — full chart configuration reference
- Product Hierarchy — product and product family setup
- Station Product Standards — per-station production targets
- Batches — batch lifecycle and product relationship