Timerange Definition

You run all the queries in a defined time range. You can define the time range using two blocks, SINCE and UNTIL.

Note Use uppercase or lowercase only, do not use mixed-case. Valid variants are since, SINCE, until, UNTIL.

Default Values

Default values for SINCE and UNTIL blocks are

SINCE -1h
UNTIL now

You need not explicitly define any of these blocks or define only one of these blocks and expect a default value for the other block.

Absolute Timestamps

You can use absolute timestamps to define both time range boundaries, since and until. Here are the following possibilities:

  • ISO-8601 date-time with offset. For example 2021-02-15T16:37:46Z or 2021-02-15T16:37:46+02:00
  • ISO-8601 date only format. For example 2021-06-17 or 2021-06-17+01:00
  • Epoch in milliseconds. For example 1623963531547
  • Epoch in the selected unit. s seconds, ms milliseconds, us microseconds. For example 1623963531s
  • Use the now function
  • Use any of the above options with + or - duration. For example now - 2h
Examples

since 2021-02-15T16:00:00Z until 2021-02-15T16:30:00Z
since now - 1h until now
since 1623963531547 until 1623963531547 + 1h

Durations / Relative Timestamps

You can define one of the since/until blocks as a relative duration compared to the other. Hence, you must always define the other as an absolute timestamp. Ensure that you prefix the duration with a + or a - sign.

Valid duration formats are:

  • ISO 8601 duration. For example PT10H or P2Y5DT10H
  • Jira-like duration using week, day, hour, minute. For example 2w 4d 1h 11m or 2h11m
Examples

since -1h until 2021-02-15T16:30:00Z
since 2021-02-15T16:30:00Z until +PT1H
since -1h until now - 1h