Allow the same query to be used multiple times in the same dashboard/tab
I've found that when I add multiple instances of a query to a dashboard but add differing filters exclusions, the exclusions on one instance affect the other instance. This effectively prevents me from having a dashboard with multiple instances of the same query that reflect different filters. Instead, I have to have to clone my query, leaving me with two identical queries.
I am setting up a dashboard to compare an individual agent's performance against the team's average performance. My thought was that I'd have two instances of the same query on the dashboard and exclude filters in such a way that one query would show individual agent data and the other would show team data. This would prevent me from having to create and manage multiple copies of the same query.
For example, I have a query for average handling time and a dashboard with filters for updater name and group. I would like to have two instances of this query on my dashboard. One instance of the query would filter based on the updater name only (exclude the group filter) and the second instance of the query would filter based on the group filter (exclude the updater name filter).
It would be nice if the different instances of the query resolved filter exclusions separately so they could be used to display different data.
-
Hey Eric, you can use dashboard feature to exclude filters from certain widgets/queries. On your copy of the query to show the whole team performance, use this to exclude your updater filter. I use this to compare individual performance to team performance for wait time trends.
-
Thanks for the response, Hillary.
I am using the exclude filter feature as you suggested. The problem is that when I exclude the filter for the first instance of a query the exclusion gets applied to the second instance as well (even though I didn't exclude the filter from that instance).
I've updated my initial comments to try and make the use case more clear.
Please sign in to leave a comment.
2 Comments