Adding totals to results

Have more questions? Submit a request

7 Comments

  • Jon Schlueter
    Comment actions Permalink

    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?

     

    1
  • Quentin
    Comment actions Permalink

    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.

     

    0
  • Kevin McCann
    Comment actions Permalink

    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.

    0
  • Jessica Blake
    Comment actions Permalink

    @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 support@zendesk.com 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 support@zendesk.com so we can look into this further.

    0
  • Chris Wooten
    Comment actions Permalink

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

    0
  • Brandon Tidd
    Comment actions Permalink

    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!

    Brandon

    0
  • Nicole Ferlo
    Comment actions Permalink

    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)?

    0

Please sign in to leave a comment.

Powered by Zendesk