When you select a time attribute for a visual, you can filter the time range displayed on the visual.
To set a time range for a time field filter:
- Select the filter icon on the visual or dashboard to access the appropriate filter sidebar.
- To access the visual filter sidebar, select its filter icon (
) or select Settings from the visual menu (
) and then select
- To access the dashboard filter sidebar, select its filter icon (
- To access the visual filter sidebar, select its filter icon (
The Filters sidebar appears showing any filters that have been applied. Select Add Filter if no filters are defined.
2. Select the Row tab. If the style of your visual is an arc gauge, KPI chart, table (raw data), histogram, or map markers chart, the Group tab is available, but you cannot create a group filter because all filters for these visual styles are row-level filters. If you are using the dashboard filters sidebar, the Group tab is not available.
The Saved tab shows saved filters that you can apply to a dashboard or visual.
3. On the Row tab, select a time field you want to use from the list of available time fields. A second page with two tabs appears in the Filters sidebar: Range.
4. If you did not apply a Nullfilter, you can use the From and To boxes to specify the time range for the filter. You can set the range in static time or dynamic time, or use preset ranges provided with Damstra Insights.
-
- Select Static Time or Dynamic Time in the fx drop-down menu.
If you select Static Time, the From and To boxes are filled with default dates and times. Use the boxes to select specific from and to times:
If you select Dynamic Time, the From and To boxes are filled with Start of Data Set and End of Data Set automatically. Use the Condition boxes to select different dynamic from and to times:
-
- Alternatively, select Presets to fill the From and To boxes with predefined time ranges provided by Insights.
Use the filter box at the top of the presets list to locate the preset setting you want. Descriptions of each of the preset options are provided in Preset Time Ranges.
5. After the filter specifics have been defined, select Continue. If you create the filter at the dashboard level, it is applied to all the visuals in the dashboard. Otherwise, it is applied only to the selected (active) visual. After confirming your changes, select Apply.
Preset Time Ranges
The following table describes all the preset time ranges available in Damstra Insights.
| Preset type | Data Cached? | Start date | End date |
| Current Hour | No | Beginning of the current hour | Current time |
| Current Minute | No | Beginning of the current minute | Current time |
| Current Month | No | First day of the current month (for example, 08/01/2018 12:00:00 AM) | Last day of the current month (for example, 08/31/2018 11:59:59 PM) |
| Current Month-to-Date | No | First day of the current month (for example, 08/01/2018 12:00:00 AM) | Current date and time |
| Current Quarter | No | First day of the current quarter (for example, 07/01/2018 12:00:00 AM) | Last day of the current quarter (for example, 09/30/2018 11:59:59 PM) |
| Current Quarter-to-Date | No | First day of the current quarter (for example, 07/01/2018 12:00:00 AM) | Current date and time |
| Current Week | No | Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) | Saturday of the week with current day (for example, 08/22/2018 11:59:59 PM) |
| Current Week-to-Date | No | Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) | Current date and time |
| Current Year | No | First day of the current year (for example, 01/01/2018 12:00:00 AM) | Last day of the current year (for example, 12/31/2018 11:59:59 PM) |
| Current Year-to-Date | No | First day of the current year (for example, 01/01/2018 12:00:00 AM) | Current date and time |
| Max Available Range | No | Minimum time value in the data set known to Damstra Insights | Maximum time value in the data set known to Damstra Insights |
| Previous Hour | No | Beginning of the previous hour (for example, Aug 20, 2018, 12:00:00 PM) | End of the previous hour (for example, Aug 20, 2018, 12:59:59 PM) |
| Previous Minute | No | Beginning of the previous minute | End of the previous minute |
| Previous Month | Yes | First day of the previous month (for example, 07/01/2018 12:00:00 AM) | Last day of the previous month (for example, 07/31/2018 11:59:59 PM) |
| Previous Month-to-Date | No | First day of the previous month (for example, 07/01/2022 12:00:00 AM) | The current date. For example, if today is 08/05/2022 12:00:00 AM, the information returned is from 07/01/2022 12:00:00 AM through 08/05/2022 12:00:00 AM. |
| Previous Quarter | Yes | First day of the previous quarter (for example, 04/01/2018 12:00:00 AM) | Last day of the previous quarter (for example, 06/30/2018 11:59:59 PM) |
| Previous Quarter-to-Date | No | First day of the previous quarter (for example, 04/01/2022 12:00:00 AM) | The current date. For example, if today is 08/05/2022 12:00:00 AM, the information returned is from 04/01/2022 12:00:00 AM through 08/05/2022 12:00:00 AM. |
| Previous Week | Yes | Sunday of the previous week (for example, 08/09/2018 12:00:00 AM) | Saturday of the previous week (for example, 08/15/2018 11:59:59 PM) |
| Previous Week-to-Date | No | Sunday or Monday of the previous week, depending on locale (for example, 07/25/2022 12:00:00 AM) | The current date. For example, if today is 08/05/2022 12:00:00 AM, the information returned is from 07/25/2022 12:00:00 AM through 08/05/2022 12:00:00 AM. |
| Previous Year | Yes | First day of the previous year (for example, 01/01/2018 12:00:00 AM) | Last day of the previous year (for example, 12/31/2018 11:59:59 PM) |
| Previous Year-to-Date | No | First day of the previous year (for example, 01/01/2021 12:00:00 AM) | The current date. For example, if today is 08/05/2022 12:00:00 AM, the information returned is from 01/01/2021 12:00:00 AM through 08/05/2022 12:00:00 AM. |
| Rolling 7 days | No | 7 days before the current date and time | Current date and time |
| Rolling 24 hours | No | 24 hours before the current date and time | Current date and time |
| Rolling 30 days | No | 30 days before the current date and time | Current date and time |
| Rolling 90 days | No | 90 days before the current date and time | Current date and time |
| Rolling 365 days | No | 365 days before the current date and time | Current date and time |
| Rolling Hour | No | 60 minutes before the current date and time | Current date and time |
| Rolling Minute | No | One minute before the current date and time | Current date and time |
| Today | No | Start of the current day (for example, 08/20/2018 12:00:00 AM) | Current date and time |
| Yesterday | Yes | Beginning of the previous day (for example, 08/19/2018 12:00:00 AM) | End of the previous day (08/19/2018 11:59:59 PM) |
Read more about Data Filtering.
Filter snippets and auto data refresh
You can use the Manage Auto Data Refresh toggle for filters to pause the default behavior of some dashboards to automatically refresh the data when you make filter changes.
If you are working with a large data set from a single source, you can disable auto data refresh in the filter snippets to make changes. With auto data refresh disabled, make your filter and filter snippet changes quickly and easily, then enable it again when you are ready to see the results of filters on refreshed data.
The Publish Filters Settings icon () is available in dashboards that:
- Include visuals linked through at least one filter snippet
- Use a single source for data.
Enable and Disable Auto Data Refresh
- Open a dashboard that includes several filter snippets, from one data source, for editing or viewing. Select the Publish Filters Settings icon (
) in the group of available dashboard icons.
- A Published Filters Setting work area opens, listing the Published and Unpublished Filters applied to the dashboard, visuals, and filter snippets in your dashboard.
- Disable the Auto Apply Filters setting. This prevents Insights from refreshing data in your filter snippets from your source when you make filter changes.
- Make your filter changes as desired.
- Select Apply to refresh your filter snippet data and view your results. Alternatively, enable Auto Apply Filters again to view your results and apply filter changes (if applicable).
Comments
0 comments
Please sign in to leave a comment.