Say I have a report, that returns the contact reason for tickets. Last month, options A, C, and D got used. This month, only A,B, and C were selected. In this scenario, my Dashboard with the query on it, will only show options A,C, and D when I have it filtered to last month, and only show A,B, and C, when I filter to this month. I need all values to show all the time, even if they are 0. I have tried adjusting metric filtering, but even when manually setting the minimum to "0" it doesn't return all the custom field values. I have also tried the "add +0" to the top metric, which didn't change the result either.
My top metric value would be Solved Tickets. This happens on both the Tickets and Tickets Updates datasets, but Tickets is the one I would prefer to use for this.
My understanding of Explore is that because it uses an Outer Left Join, Tickets *should* be joining Custom Field and displaying 0 for any values where # Tickets is 0. This is not happening, because of a "COALESCE" in the Zendesk SQL.
Is there any way achieve this? I want people who are emailed reports to get the same fields in the same rows of the excel version, every time. I do not want the values included changing every time, which is what is happening now.
How can I get a query to always show *all* field value options?
+100, I too have enterprise customers who would like to be able to pull reports in the same Fashion. my customers often have to pass their reports on to upper management and keeping them in the same format is very valuable versus the confusion which is caused now when people don't read the report correctly.
It's also frustrating that new tags and ticket field options can't be displayed as NULL when they are first created. Having to wait a week for fields to be used seems unneeded.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.