I'm working on creating a report in Explore to look for tickets where the custom date field on the organization's profile is not blank (NULL).
While reviewing the results of the query, I noticed the data presented was inaccurate. Upon further investigation, I discovered Explore is returning results based on the Requester's Organization and not the Ticket Organization. This is a problem for end user profiles with multiple organizations as I don't need their default organization. I need the Ticket Organization.
Anyone know if there is a way I can get Explore to display the Organization Custom Field data based on the Ticket Organization instead?