What is the purpose or meaning of the default Dashboard time filter reflecting created/solved?Answered
When I clone the default Support dashboard, and look at the properties of the time filter, it indicates that it is applied against the ticket solved AND ticket created fields. Is this a statement that it's all tickets solved OR created within the range, or tickets solved AND created?
In the OR case, this seems to make sense, but in testing it looks like the filter is being expressed as the AND case. If that is correct, that data reflected in the widgets/queries is only for tickets both created AND solved within the range, is there a specific value or meaning or story to this logic window? (ie Solve date could be described as 'What we worked on' and create date could be described as 'What we're working on'.)
From here, why are different data points excluded in the default simple queries? Like, I apply the AND filter above, but the for the Tickets Created, it excludes solve date, which is a component of the date filter; the same with the unsolved tickets, but it's excluding solve date. Is this some kind of compensation for using the AND version of the filter?
Is this compensation is part of the Explore recipe design pattern, and should I be building these filter exceptions into every query or checking whether I need to strip them whenever I create them?
I revised my date filter to filter on date updated, and to pull in data for tickets updated in the date range. It's noisier reporting, but it foots. Is there a way of stripping out the 'exclude filters' settings of multiple widgets in bulk?
I was told to file a "feature request" about this when I reported it, you're completely right, this prebuilt Dashboard is misleading and returns incorrect data and makes it look like you can report in ways that simply are not possible in Explore.
There's another part to this that I think will help explain how it *can* work to have a time filter with multiple measurements, and apply those selectively to the reports on the Dashboard. You can exclude time filters from specific queries on Dashboards. This means you can have a Time Filter that can do both "Tickets Created" and "Tickets Solved" for the date range it is set to, but only apply one, or the other, or both to the individual reports on the Tab, by excluding specific time metrics from being applied to specific reports.
Please sign in to leave a comment.