Datasets

Relative offsets: -24h , -48h , -7d , -14d , -30d , -90d , -12m , -1y
Keywords: today , yesterday , this_week , last_week , this_month , last_month , this_quarter , last_quarter , this_year , last_year
Rolling windows: past_7_days , past_14_days , past_30_days , past_60_days , past_90_days , past_180_days , past_365_days
ISO timestamps: 2025-03-15 or 2025-03-15T10:30:00Z

LayersQL provides seven datasets for building metrics. Each dataset exposes its own metrics, dimensions, and example queries.

Dates (all datasets)

All datasets accept the same date expressions in the SINCE clause:

⌘I