Explore recipe: Percentage of tickets created by channel

Have more questions? Submit a request

4 Comments

  • Laura Weiler
    Comment actions Permalink

    I am trying to use this recipe to show the percent of tickets by organization. I am able to get the chart to show correctly. However, I would like to filter down to our top 10 organizations that submit tickets. When I filter down (using the top/ bottom result manipulation), the percentages recalculate to show the percent of total for just those 10 organizations instead of percent of all tickets. Is there a way to maintain the percent as a percent of total tickets?

    0
  • Shera Esquivel
    Comment actions Permalink

    Hi Laura,

    Good day!

    To maintain the percentage of all tickets, hit the 'aggregate filtered results' box in the setup, that should give you a 'bucket' of all the other channels, so the % stay correct, here's an example:


    I hope this helps!


    0
  • Donald Beckworth
    Comment actions Permalink

    This is very helpful. Thank you. I was able to replicate this in a query with multiple groups and multiple statuses. However, only being able to set to rows OR columns limits the sub\grand total aggregation to either\or. So the column grand total percentages all equal 100% and the rows correctly show the broken down percentage, or vice versa.  Is there a way to do this so that the percentage of total for the grand sum row&column both show the percentage of total? 

    0
  • Shera Esquivel
    Comment actions Permalink

    Hi Donald,

    Good day!

    I apologize for the delay, but then the total wouldn't be the total of the results broken down by row or column? You can set the % to be % of the total on the whole result, though.

    Just to confirm, is this what you're after?


    0

Please sign in to leave a comment.

Powered by Zendesk