Time filter isn't working when I choose a time frame

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

1. Open the dashboard and click Edit in the top tools bar.
2. Click the Time filter you want to edit and then click the arrow pointing down.
3. 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.
   
   
4. Click Close.

When you select a time attribute, you are 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, exclude the time filter from any unrelated queries.

To exclude a time filter from a query

1. Open the dashboard and click Edit in the top tools bar.
2. Click the query you want to exclude and then click the arrow pointing down.
3. Click Exclude filters and then Time filters. 
4. 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.
5. Click Apply.

Once you finished customizing the dashboard, publish the dashboard to save any changes made.

For more information about filters, see the article: Adding interactive dashboard widgets.