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 report results based on the selected time filter date range, select the appropriate date attributes for the applicable datasets based on the reports embedded on your dashboard.
To apply the time filter to the appropriate report
- 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 report you want the filter to impact in this dashboard.
- 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 reports that use the Support: Tickets 1 dataset as the ticket creation date. To prevent this, exclude the time filter from any unrelated reports.
To exclude a time filter from a report
- Open the dashboard and click Edit in the top tools bar.
- Click the report 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 report.
In this example, the tickets_solved_at time filter doesn't interfere with the tickets_created_at based report. - Click Apply.
Once you finished customizing the dashboard, publish the dashboard to save any changes made.
See below for a video demonstration of both of the issues in this article: