Adding totals to results

Return to top
Have more questions? Submit a request


  • Jon Schlueter

    I added "Sum" for the total, which helps in columns B and D, but it doesn't make sense for column C.  Can you please help me understand how I can add up a total here and have the percentage to be accurate?


  • Quentin

    Similar question here, it was possible in Gooddata to choose which total you want to show for a specific column, for example here I want to have the SUM for solved tickets and agent replies but the AVG for FRT.


  • Kevin McCann

    Is there a way to add the totals to stacked barcharts? In the Edit Configuration pane, under "Chart" there is a checkbox for "Stacked: Show total values" but when I check it, the visualization does not change.

  • Jessica Blake
    Zendesk Team Member

    @Jon from a cursory look at your query, it looks like your metric is reporting on the percentage of tickets with FRT < 30 minutes per agent, which is why the sum is not adding up to 100%. If you still have concerns about this, please send a ticket to so we can check out your query.

    @Quentin there's no way to show the sum for ticket updates count and then the average for the first reply time per your request. Instead from Result manipulation>Totals>Advanced you can add both the sum and the average to the chart. Check out the screenshots below:


    @Kevin sometimes the query will hide the total values when there is not enough room on the bar chart to show both sets of values. Try clicking on Chart configuration>Displayed values and change the Position setting to Inside.

    If that doesn't work, please send a ticket to so we can look into this further.

  • Chris Wooten

    Does anyone know how to just display the totals and not the rows behind the totals?

  • Brandon Tidd
    Community Moderator

    HI Chris Wooten -

    A couple of options here.  First, you could just change your configuration type to a format that's more suitable, such as a table).

    The other option would be to change the color of your bars to the same as the background color.

    Hope this helps!


  • Nicole Ferlo

    I tried adding totals to both rows and columns, but I can only get the totals to appear for the columns.  Any ideas why I can't see the totals at the end of the rows?  Is there a limit to the number of columns I can have in a table (this one has 117)?

  • Devan - Community Manager
    Zendesk Community Team

    Hello Nicole Ferlo,

    The problem you are running into is due to the number of columns you have. This is going to distort your table and make viewing data rather problematic. My recommendation would be to trim down the number of columns if possible. I've shared an article that breaks down how to set up your table to avoid these issues. 

    Working with tables

    Best regards. 

  • Damien Messe


    We have queries with several metrics like the one below and I don't know to hide the Total on satisfaction score and one touch tickets as it makes non sense to display it.

    A simple hide button will make it easy but I'm able to find any option to do it...

    Is there any easy to only display the Total of tickets ?

  • Brett Bowser
    Zendesk Community Team

    Hey Damien,

    You should be able to hide a metric following the instructions here:

    Can I hide the metrics column in an Explore query table?

    Let me know if that's not what you're looking for.


  • Sydney Neubauer

    We have added Sum Totals on rows and columns and then sorted the rows to be in ascending order which changes where the sum total is located. Is there a way to exclude the total from being sorted? Or a way to pin it? 

  • Kate L.

    Hi Sydney,

    I created a sample query in my test account and I did see that the Sum Totals stay in the same position. I have created a ticket on your behalf so we can look into your query further.

  • Brandon Tidd
    Community Moderator

    Hey Sydney Neubauer - 

    Sorry for the delay here.  You can use the advanced sort feature under results manipulation to keep that sum in place!

  • Charlie Smith

    Not sure how possible this is, but I'm trying to show the average of two totals. Is there a way to have this calculated and show using the KPI visualization? 


Please sign in to leave a comment.

Powered by Zendesk