Time ranges
Tell supports relative ranges, predefined periods, and custom date ranges. Relative ranges — look back from today:| Range | Meaning |
|---|---|
7d | Last 7 days |
30d | Last 30 days |
90d | Last 90 days |
3m, 6m, 12m | Last 3, 6, or 12 calendar months |
1h, 24h | Last 1 or 24 hours |
| Range | Meaning |
|---|---|
today | Today |
yesterday | Yesterday |
wtd | Week to date |
mtd | Month to date |
qtd | Quarter to date |
ytd | Year to date |
last_week | Previous complete week |
last_month | Previous complete month |
last_quarter | Previous complete quarter |
last_year | Previous complete year |
all_time | All available data |
Granularity
Control how data is bucketed in time. The default isdaily.
| Granularity | Aliases |
|---|---|
minute | min, 1m |
hourly | hour, 1h |
daily | day, 1d |
weekly | week, 1w |
monthly | month |
quarterly | quarter |
yearly | year, 1y |
Filter conditions
Add conditions to narrow down which data is included. Each condition has a field, operator, and value.Operators
| Operator | Aliases | Description |
|---|---|---|
eq | =, == | Equal |
ne | !=, <> | Not equal |
gt | > | Greater than |
gte | >= | Greater than or equal |
lt | < | Less than |
lte | <= | Less than or equal |
contains | like | Contains substring |
not_contains | not_like | Does not contain substring |
starts_with | Starts with | |
ends_with | Ends with | |
in | In list of values | |
not_in | Not in list | |
is_set | isset | Field is not null |
is_not_set | isnotset | Field is null |
regex | ~ | Regex match |
API format
Pass conditions as query parameters:JSON properties
Filter on custom event properties using dot notation. Properties stored in the JSONproperties column are accessed as properties.field_name:
properties.user.role.
Breakdowns
Add a breakdown to split any metric by a dimension:device_type— desktop, mobile, tabletcountry— country codeoperating_system— OS nameevent_name— event typelevel— log level (for log metrics)source— data source- Any
properties.*field
Comparison
Compare the current period to a previous one:| Mode | Aliases | Compares to |
|---|---|---|
previous | prev, previous_period | Same duration, immediately before |
previous_year | yoy, year_over_year | Same dates, one year earlier |
comparison object with previous_total, change (absolute), percent_change, and optionally the previous period’s data points.
Limits
Results are capped at 10,000 rows by default. For raw drill-down queries, setlimit explicitly: