Unexpected behaviour of query filters and dashboard filters
Unfortunately i have experienced the filter in the query doesn't limit the data can be view from the same query in the dashboard.. For example the follow query is filtered with ticket created data from the last month:
and in the kpi dashboard is the same until the date filter is identical (ticket created data from the last month):
But if i expand the range date in the dashboard the kpi data is update with the new date selection, even if the date in the query filter is still filtered with ticket created data from the last month:
Why do i have managed filter at the query level if in the dashboard they can be override?
Another example: at the query level i could apply this filters:
in the dashboard i can filter the group and it gives to me a nonsense result like this:
because none of this ticket have the "Second level" group as assignee.
But if, at the query level, i apply this kind of filters (excluded) in other hand:
in the dashboard i can filter the group, again, and it gives to me this result:
that are, in this case, the ticket that are assignee to the "Second level" group and i don't want to show in the result of the query and don't want to show in the result of the dashboard..
Please could you help me to understand the filters interaction between the query level and the dashboard level?
You will need to select the query you don't want the Dashboard level filter to apply to, go into it's "Exclude Filters" settings, and make sure to check off "Created at - Date". That will prevent the filter on the Dashboard from applying to that specific metric.
Here's some documentation around excluding filters on the Dashboard: https://support.zendesk.com/hc/en-us/articles/4408846768026-Best-practices-for-using-dashboard-filters#h_9b64cfc6-4559-4ca9-a15d-f740441bc58e
Hi CJ Johnson, thanks for the reply.
I know there is the opportunity to exclude some dashboard filters but my purpose is to not exclude them and understand how the query filters and the dashboard filters interact in some manner..
As you can see the same filter in the dashboard have different result with different filter in the same query, also if the logic in the filter of the query should be practically the same..
Please sign in to leave a comment.