Examples

A set of complete queries you can paste into the report editor and adjust. Each one names a dataset, shows a metric or two, and adds the clauses needed to answer a real question. See Datasets for the metrics, dimensions and filters each one exposes.

Top sellers last month

Your best products by revenue, with the units behind them.

FROM sales
  SHOW total_revenue, units_sold
  GROUP BY product
  DURING last_month
  ORDER BY total_revenue DESC
  LIMIT 20

Revenue by vendor, month over month

Revenue per vendor last month, each with its change against the month before.

FROM sales
  SHOW total_revenue
  GROUP BY vendor
  DURING last_month
  COMPARE TO previous_period
  ORDER BY total_revenue DESC

What needs reordering

The SKUs running low, soonest to run out first.

FROM inventory
  SHOW days_of_supply, current_quantity, units_to_order
  GROUP BY sku
  WHERE needs_reorder
  ORDER BY days_of_supply ASC

Dead stock, ranked by cash tied up

Products with no recent sales, most valuable first, so you clear the biggest wins.

FROM inventory
  SHOW inventory_value
  GROUP BY product
  WHERE dead_stock
  ORDER BY inventory_value DESC

Return rate by reason

Why customers send things back, and how much.

FROM returns
  SHOW units_returned
  GROUP BY reason
  ORDER BY units_returned DESC
  VISUALIZE units_returned TYPE donut

Least reliable suppliers

On-time delivery rate per supplier, worst first, with how late they run on average.

FROM supplier_performance
  SHOW on_time_rate, deliveries, avg_days_late
  GROUP BY supplier
  ORDER BY on_time_rate ASC

Inventory value by vendor

Where your stock value sits, as a donut.

FROM inventory
  SHOW inventory_value
  GROUP BY vendor
  ORDER BY inventory_value DESC
  VISUALIZE inventory_value TYPE donut

Sales trend over the last year

Revenue by month, to see the shape of the year.

FROM sales_history
  SHOW total_revenue
  TIMESERIES month
  SINCE -12m UNTIL today

Units sold next to stock on hand, by vendor

Combine two datasets with + to pull metrics from both. Here last month’s units sold sit beside the units you hold now, per vendor, so fast sellers running low and stock that is not moving both stand out in one report.

FROM sales + inventory
  SHOW units_sold, total_quantity
  GROUP BY vendor
  DURING last_month
  ORDER BY units_sold DESC

A vendor with sales but no stock left has sold out; one with stock but no sales is sitting dead. See FROM and SHOW for how combining works.

Introduction

Syntax

Datasets

Examples

Top sellers last month

Revenue by vendor, month over month

What needs reordering

Dead stock, ranked by cash tied up

Return rate by reason

Least reliable suppliers

Inventory value by vendor

Sales trend over the last year

Units sold next to stock on hand, by vendor

​Top sellers last month

​Revenue by vendor, month over month

​What needs reordering

​Dead stock, ranked by cash tied up

​Return rate by reason

​Least reliable suppliers

​Inventory value by vendor

​Sales trend over the last year

​Units sold next to stock on hand, by vendor

Top sellers last month

Revenue by vendor, month over month

What needs reordering

Dead stock, ranked by cash tied up

Return rate by reason

Least reliable suppliers

Inventory value by vendor

Sales trend over the last year

Units sold next to stock on hand, by vendor