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.
Please sign in to leave a comment.