How to filter rows based on column totals

Answered

2 Comments

  • Official comment
    Taylor Bowser
    Comment actions Permalink

    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,  

  • Corey Nunn
    Comment actions Permalink

    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

    0

Please sign in to leave a comment.

Powered by Zendesk