This article shows how to display data within a specific time range. You can quickly select from commonly used relative time ranges (e.g. 'This week'), or set start and end times. The default time range is 'Last 15 minutes.
Table of contents
Terminology
Term | Definition |
Absolute | A specific date with optional time. Absolute dates refer to a specific point in time that will not change. E.g. 2019-10-01T14:00:00.000 for 14:00 on 1st October 2019. |
Relative | A point in time relative to 'now'. Eg 10 days ago. Relative points in time will always shift to keep the same duration before or after 'now'. |
Now | Setting the time to "now" means that on every refresh this time will be set to the time of the refresh. |
Quick select
1. Click to open the time picker popup.
2. Select a time range from the following options:
- Quick select: to use recent time ranges, click previous (<) and next (>) arrows to move the time window backwards and forwards.
- Commonly used: select one of the available time ranges
- Recently used date ranges: to use a time range you have recently selected.
- Refresh every: to set a time interval for the visualization or dashboard to refresh automatically
Note: change is applied automatically when you select an option.
Set start and end time
1. Click the time range bar next to the quick select icon.
2. Click on the start date to open the time picker popup.
3. In the popup,
- Select Absolute, Relative or Now
- Specify the time as you want
4. Click on the end date and set the end time.
5. Click Update to apply changes.
Tip: If you work with an absolute time range and need to use it multiple times, you can create a time range filter to use later.
Use time range filter
1. Click Add filter on the left-hand side
2. Select the field that determines the timestamp in your dataset.
3. Select "is between" as operator.
4. Set date and time:
- The time needs to be in ISO format (or milliseconds from the epoch).
- The date is mandatory while the time is optional.
- Example of valid format:
- Date and time: 2021-10-01T14:00:00.000
- Date: 2021-10-01
5. Add a custom label for later use.
6. Click Save.
Note: The time range filter should be a subset of the time range picker. It can cause "no results" if the time range filter is outside the time range selected from the time range picker.
Further reading
Comments
0 comments
Please sign in to leave a comment.