Test Collection - low stock

Daily Low Stock Report Script : 

FROM inventory
  SHOW ending_inventory_units, ending_inventory_value
  WHERE inventory_is_tracked = true
  GROUP BY product_title, product_variant_title, product_variant_sku,
    inventory_item_cost WITH TOTALS, CURRENCY 'USD'
  HAVING ending_inventory_units >= 1
    AND ending_inventory_units < 10
  DURING today
  ORDER BY product_title ASC
  LIMIT 1000
VISUALIZE ending_inventory_units TYPE table

For 1 Month Stock Report : 

FROM inventory
SHOW ending_inventory_units, ending_inventory_value
WHERE inventory_is_tracked = true
  AND product_status = 'active'
GROUP BY product_title, product_variant_title, product_variant_sku, inventory_item_cost
HAVING ending_inventory_units >= 1 AND ending_inventory_units < 10
WITH TOTALS, PERCENT_CHANGE
SINCE startOfMonth(-1m)
UNTIL endOfMonth(-1m)
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_units TYPE table

For showing only active products low inventory (today) : 

FROM inventory
SHOW ending_inventory_units, ending_inventory_value
WHERE inventory_is_tracked = true
  AND product_status = 'active'
GROUP BY product_title, product_variant_title, product_variant_sku, inventory_item_cost
HAVING ending_inventory_units >= 1 AND ending_inventory_units < 10
WITH TOTALS, PERCENT_CHANGE
SINCE today
UNTIL today
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_units TYPE table