How can I get a query to always show *all* field value options?
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 happ