Time dimensions enable time-series analysis with automatic date grouping.
Note
Tip: Views like Sales and ItemSales support the same time dimension patterns shown below. For most reporting, use Sales.local_reporting_timestamp for time-series analysis on the Sales view.
{ "measures": ["Orders.net_sales"], "timeDimensions": [{ "dimension": "Orders.sale_timestamp", "dateRange": ["2024-01-01", "2024-01-31"], "granularity": "day" }] }
{ "dimension": "Cube.time_dimension", // Required: which time field "dateRange": ["start", "end"], // Required: date range "granularity": "day" // Optional: grouping level }
| Granularity | Description | Example Use Case |
|---|---|---|
hour | Hourly buckets | Intra-day analysis |
day | Daily buckets | Daily sales reports |
week | Weekly buckets | Weekly trends |
month | Monthly buckets | Monthly performance |
quarter | Quarterly buckets | Quarterly reports |
year | Yearly buckets | Year-over-year analysis |