How to filter rows based on column totals
BeantwortetI 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!
-
Offizieller Kommentar
Hi Corey,
Thanks for reaching out in our Community!
I attempted a few things in my test account but wasn't able to successfully filter on the totals column to show tickets greater than a specific value. However, I was able to find a workaround in the meantime that will allow you track the total COUNT(Tickets) which you can break down by ticket channel using the decompose interaction.For example, I created a query in my test account to show COUNT(Tickets) sliced by Ticket Organization Name.
Next, I went to result manipulation>>metric filter to restrict this to show values greater than 10 (it would be 1000 in your case).
Once your results are filtered, you'll be able to click on an individual cell and select decompose. The next window will allow you to choose with attribute you would like your results to be broken down by (Ticket Channel).
Which will return results that look like these:
While I know it's not exactly what you were looking for, I hope you find this helpful to achieve similar results in the meantime. I'd also be happy to mark your request for internal product feedback for our team as I understand it would be useful to be able to apply a metric filter to totals/subtotals.
Best, -
actually, i think the Top 10 will do the trick! But if you do find a way to do what I was asking, let me know as that would probably be helpful because I would like to create multiple tiers for separate reporting!
EDIT: scratch that, this only works on tables. top 10 doesn't seem to apply to visualization
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
2 Kommentare