TIMESERIES

TIMESERIES breaks your results into time buckets across the date range, so you can see how a metric moves over time. Choose one grain: day, week, or month.

FROM sales
  SHOW total_revenue
  TIMESERIES week
  DURING last_quarter

Each bucket in the range gets a row, including quiet periods with no activity, so a line or bar chart reads as a continuous trend. Pair it with a date clause to set the window, such as DURING above. A timeseries is a single trend across your whole shop, so it cannot be combined with GROUP BY. To plot the trend as a chart, add VISUALIZE with a line or bar type, and to overlay events like restocks or stockouts use ANNOTATE.

Introduction

Syntax

Datasets

Examples