Explore: Stock Levels
Warehouse = All
Category = All
Add Filter
Explore from here
Inventory Dashboard
Field Picker
STOCK
Dimensions
SKU DIM
Product Name DIM
Category DIM
Current Qty DIM
Reorder Point DIM
Days of Supply DIM
Is Low Stock DIM
WAREHOUSE
Dimensions
Name DIM
Location DIM
Measures
Utilization % MEAS
Visualization
Data
SQL
Bar
Line
Scatter
Table
Query ran in 0.8s — 6 rows
Last run: just now
Current Stock vs Reorder Point by Category
Results — 6 rows
SKU Product Category Current Stock Reorder Point Days Left Status
FB-001 Grower Blend 18% Feed Blends 84t 40t 18 OK
FB-002 Finisher Blend 16% Feed Blends 51t 30t 11 OK
SP-011 Vitamin Premix A Supplements 32t 25t 9 Watch
SP-014 Lysine Concentrate Supplements 18t 20t 5 Low
AD-003 Mycotoxin Binder Additives 18t 15t 7 Watch
AD-007 Acidifier Pro Additives 9t 12t 3 Low
Show SQL
-- Generated by Looker · bigquery_prod · Explore: stock_levels SELECT s.sku_id AS `stock_levels.sku`, s.product_name AS `stock_levels.product_name`, s.category AS `stock_levels.category`, s.current_qty AS `stock_levels.current_qty`, s.reorder_point AS `stock_levels.reorder_point`, s.current_qty / NULLIF(s.avg_daily_consumption, 0) AS `stock_levels.days_of_supply`, s.current_qty < s.reorder_point AS `stock_levels.is_low_stock` FROM `inventory_prod.stock` AS s LEFT JOIN `inventory_prod.warehouses` AS w ON s.warehouse_id = w.warehouse_id ORDER BY s.current_qty / NULLIF(s.reorder_point, 0) ASC LIMIT 500
Portfolio