Issue Symptoms
I created a custom dashboard and set up a time filter but it doesn’t work correctly when I choose a time frame.
Resolution Steps
When you add a time filter to a dashboard to filter query results based on the selected time filter date range, you also need to select the appropriate date attributes for the applicable datasets based on the queries embedded on your dashboard.
To apply the time filter to the appropriate query
- Open the dashboard and click Edit in the top tools bar.
- Click the Time filter you want to edit and then click the arrow pointing down.
- Select Edit filters and search for the attributes you want to filter. Select the datasets related to the query you want the filter to impact in this dashboard.
- Click Close.
When you select a time attribute, you are actually applying the time filter widget to that time attribute rather than filtering it. For example, when "Support: Tickets 1 - tickets_created_at" is selected, the time filter widget applies the specified date range to any queries that use the "Support: Tickets 1" dataset as the ticket creation date. To prevent this, you need to exclude the time filter from any unrelated queries.
To exclude a time filter from a query
- Open the dashboard and click Edit in the top tools bar.
- Click the query you want to exclude and then click the arrow pointing down.
- Click Exclude filters and then Time filters.
- Select the elements that you don't want to be applied to that query.
In this example, the tickets_solved_at time filter doesn't interfere with the tickets_created_at based query. - Click Apply.
Once you finished customizing the dashboard, publish the dashboard to save any changes made.
For more information about filters, see Adding interactive dashboard widgets.
2 Comments
So as a general rule of thumb, how do I gauge whether or not I need to exclude time filters on different datasets within the dashboard that I build?
Hi Sam,
Great question - it will depend on which attribute(s) you have already selected for your time filter (see this article section). For example, let's say you have 2 queries on a dashboard and selected Attribute #1 and #2 in your time filter. If you only want Attribute #1 to apply to the first query and Attribute #2 to apply to the second query, you would exclude Attribute #2 from the first one and Attribute #1 from the second.
In other words, you won't need to exclude other attributes from either queries because those attributes were not selected on the time filter. For more information on our best practices for using dashboard filters, check out this article.
Thanks,
Eric
Please sign in to leave a comment.