I have a report of number of tickets by channel for each of our customer organizations. However, I'd like to only include in this report those organizations who have generated say 1000 tickets this year. I have created a report and have the numbers but can't figure out how to limit the organization names to only include those with over 1000 total.
I did try writing a custom metric but it counts each column separately so only those with at least 1000 in a given channel appeared. I'd like to filter it by the total tickets across all channels.Would this be through the HAVING statement? Any ideas here?
I could manually filter, but obviously, i'd like the report to be dynamic in case clients needs grow!
Please sign in to leave a comment.