The timeframe selector allows you to filter and analyze data according to specific timeframes by entering a from and to value or choosing one of the listed presets. The timeframe selector’s time zone is based on the time zone set in your user settings.
Presets are common timeframes that can be selected with a single click, like Last 2 hours
or Today
.
A custom timeframe consists of a from
and a to
value. To define a custom timeframe, enter it in the input field and press Apply.
From and to can be either absolute or relative.
Use the calendar for quick date selection. Increment or decrement the highlighted part of the timeframe, like day, month, year, hour, or minute, by using the up ↑
and down arrow ↓
keys of your keyboard.
The date and time format is localized according to your user settings. The time precision depends on the use case of your context and is determined by the app. Common time precisions are hh:mm
and hh:mm:ss
.
For more fine-grained time precision in your data analysis, we recommend exploring your data with DQL and Davis CoPilot in Notebooks.
A relative time is always calculated relative to now
. For past dates, it follows the format -[number][unit]
and for future dates +[number][unit]
.
Example
Description
-2h
2 hours ago
-7d
7 days ago
-1w
1 week ago
Supported units are s
(seconds), m
(minutes), h
(hours), d
(days), w
(weeks), M
(months), q
(quarters), y
(years).
A combination of these units (e.g., -1d3h30m
) are not supported by the timeframe selector.
An example of a simple rounded time is “beginning of today,” which is written as @d
. Rounded time expressions enable you to filter for timeframes like “Today” (@d
to now
), “Yesterday” (-1d@d
to @d
), or “Previous week” (-1w@w
to @w
).
Rounded times are calculated rounded down to a given unit. A rounded time is a special form of a relative time, thus always relative to now
.
The simplest form of a rounded time is @[unit]
. More complex variations, for example, in combination with timeframe offsets, like -[number][unit]@[unit]
or +[number][unit]@[unit]
are also possible.
Example
Description
@d
Beginning of today
-2M@M
The beginning of the previous month
@y
Beginning of this year
Rounded timeframe expressions are available in the timeframe selector and in DQL.