Suite | Professional, Enterprise, or Enterprise Plus |
Support with | Explore Professional or Enterprise |
This article outlines some of the best practices you can use to help you get the most from dashboard filters. To learn more about filters and how to add them to your dashboard, see Adding interactive dashboard components.
This article contains the following sections:
- Use reports from fewer datasets
- Select time filters you need
- Link data filters
- Exclude filters from reports
- Use time filters
- Save default filter values
- Use filters across multiple tabs
Use reports from fewer datasets
To simplify the dashboard filtering process, don't use reports from too many datasets. Typically, one or two datasets will provide enough data. For example, reports in the most common prebuilt dashboard tabs are based on one dataset.
Sometimes, you'll need to add reports from multiple datasets to a dashboard. In such situations, review the reports in the tab to ensure they can't be created from the same datasets.
For more information about the metrics and attributes contained in each dataset, see Understanding Explore datasets.
Select the time filter attributes you need
Each dataset has multiple time attributes. All these attributes are listed in the time filter menu and can be used to filter the dashboard tab. If reports added to the dashboard are from multiple datasets, then time attributes from multiple datasets will be available in the filter menu.
The goal is to select only those time attributes that you actually want to use for filtering the reports in the tab. Typically, you will need one to three time attributes per tab. For example, the Tickets tab of the default Support dashboard uses two attributes for time filtering, Ticket created and Ticket solved.
Link data filters
If you use more than one dataset in the same dashboard, you must link data filter attributes to the equivalent attributes from other datasets.
For example, the Satisfaction tab of the default Support dashboard uses reports from two datasets: Tickets, and Updates history. The data filters are based on the attributes from the Tickets dataset. To ensure that these filters are applied to all reports, they are linked with attributes from the Updates history dataset.
Exclude filters from reports
There are three main reasons for excluding dashboard filters from individual reports:
- You are using more than one attribute in the time filter
- You don't want some of the reports to be affected by a specific filter
- A dashboard filter might override results returned from a filter on the report itself
Dashboard filters can be disabled for each report via the Exclude filters setting. See Excluding reports from dashboard filters.
Use time filters
When using time filters on dashboards, it’s better to select a specific time limit rather than the All history value. Selecting All history means that no time frame is selected. In other words, it doesn’t filter any report on the dashboard. Additionally, the All history value isn't included in the new Explore dashboard builder.
As a result, if some reports on your dashboard have report-level filters, they will still apply even when the reports are viewed from the dashboard because All history doesn’t override them.
Save default filtered views
Values selected from a dashboard filter are not automatically saved. Therefore, the filter selections are reset each time the dashboard is accessed or reloaded. Because of this, it's important to set the default view for each dashboard tab. This is especially important if a time filter is used in the tab or the dashboard will be scheduled for email delivery or shared externally. For help with bookmarks, see Bookmarking dashboard states with filtered views.
Use filters across multiple tabs
With the correct configuration, you can make data filters, time filters, and live data filters work across multiple dashboard tabs. To do so, add the same filter to each tab you want it to affect. See Filtering results across multiple tabs.
35 comments
Martin Marino
Hi!
I have a dashboard with multiple filters that interact with graphs. However, when one filter is applied, it does not condition the rest of the filters. For example, if I have a user in the "Solution Type" filter with a value of "Core", and another called "Organization" with a value of "BANMEDICA", and I only want to filter by applicants who meet those requirements with a dedicated filter, all applicants from all organizations appear. Like there's no filters.
My idea is for the filters to be linked to each other, but I'm not sure if this is possible in Zendesk Explore.
0
Dan Borrego
I would like to see some examples, so I am creating a ticket for this comment and you can provide me with some extra information there.
Thanks,
0
Menzer Joan
I checked with the agent and no tickets were deleted. We are also seeing the number increase from the report delivery snapshot and the live dashboard - example:
Delivered 12/12:
Viewing 12/13:
0
Dave Dyson
Is it possible that tickets were deleted between those two dates? Deleted tickets are not shown in Explore: Deleting tickets
0
Menzer Joan
Hi - I have a dashboard which is set with a bookmark to filter (at the dashboard level) for tickets created, unsolved, solved "Last Week" (11/28 - 12/4) I have scheduled delivery for Sunday. For some reason the number of created tickets has changed from the snapshot that I received on Sunday (12/5) to today (12/8). I think I can understand why unsolved/solved might change, but wondering why the number of created tickets would change?
Received 12/5:
Dashboard 12/8:
0
Giuseppe
Hi Crawford,
Based on my testing, if you have multiple data filters on a dashboard, but they are for the same attribute (for example, if you have 2 data filters and both of them are for Submitter role, one for Tickets dataset and one for Ticket updates dataset), then the linking will only apply to whichever filter you set the link to.
Let's say, like in the scenario above, in my dashboard, I have 2 data filters, one for Ticket dataset which is for Assignee Name (Widget 1 1), and the other for Ticket Updates dataset, for Assignee name as well (Widget 2). I change the settings for Widget 1 and link this to the Ticket Updates dataset. That means, if I change the filter value for this, then it will affect my Ticket Updates dataset query.
On the other hand, in the same dashboard, if I make changes to the Widget 2, then it will still only affect the Ticket Updates queries.
0
Crawford Philleo
Hello - when linking data filters between data sets on a dashboard, is it required to link them from both filter widgets, or do you only need to do it for one of them? For example, if I have a "Submitter role" filter on a Tickets Data set filter, and an equivalent one on the Ticket Updates Data set, is it sufficient to Link via the Tickets filter only, or do you need to do this from one to the other on BOTH of them?
0
Rosie
The clickable link features is available for ID attributes like Ticket ID, User ID and Organization ID. I'm afraid this is available with updater email or agent email.
If you believe that this functionality would be a welcome addition to Explore, I encourage you to create a new post in the General Product Feedback - Reporting and analytics (Explore) https://support.zendesk.com/hc/en-us/community/topics/1260801325209-Feedback-Reporting-and-analytics-Explore- in our community to engage with other users who have similar needs and discuss possible workarounds. Conversations with a high level of engagement ultimately get flagged for product managers to review when they go through roadmap planning.
Specific examples, details about impact, and how you currently handle things are helpful for our product teams to understand the full scope of the need when working on solutions.
We truly value customer feedback and your voice and votes in the forums help influence future Zendesk functionality.
0
Jacob the Moderator
Hi James,
Not sure exactly what the cause of your issue is, but I suspect it could be either a hidden bookmark or maybe the queries themselves are excluding the filter you want.
I hope this helps.
0
James McCoy
I want to align all the Satisfaction charts to use Ticket Created Date, but when I change the dates I want to use in the filter config AND the query config, none of the data actually filters. Even when I modify the queries themselves and replace 'Ticket solved Date' with 'Ticket created Date', the data seems to remain tethered to its preferred date perspective.
How do I tell the Satisfaction tab to filter EVERYTHING by Ticket created date?
0
Sign in to leave a comment.