In Explore, you can find the total of your overall results or subtotals for individual categories in a query. Each total can be calculated with a unique aggregator (see Changing metric aggregators). You can configure totals in two different ways in Explore:
- Simple totals let you add a row of grand totals and a row of subtotals, using any of Explore's aggregators. Grand totals will calculate the overall total of your results, using your chosen aggregator. Subtotals can be used if you have more than one attribute added to your query.
-
Advanced totals let you to add multiple rows of totals each with a different aggregator. Grand totals will only be applied to the first attribute on the selected location. Subtotals are only available for the first attribute on Rows. If you have attributes on Columns, subtotals will not be an available action.
Note: Advanced totals can only be used with the Table visualization option.
To add simple totals to your query
- In Query Builder, click the result manipulation icon (
).
- Select the Totals option.
- Underneath Grand totals on, check the location of the attributes for which you want to apply grand totals. You can select Columns, Rows, or both.
- Select an aggregator.
- Underneath Subtotals on, check the location of the attributes where you would like to apply subtotals. You can select Columns, Rows, or both.
- Select an aggregator.
- When you are finished, click Apply.
To add advanced totals to your query
- In Query Builder, click the result manipulation icon (
).
- Select the Totals option.
- Click the Advanced tab (this is only visible if your visualization type is Table).
- Click + Add a new total.
- Underneath Attribute select the location of the attribute you want to apply your total to. You can calculate grand totals on either Columns or Rows, and subtotals on an individual attribute.
Note: You can only calculate subtotals on the first attribute listed in Rows. If you have an attribute in Columns instead, subtotals will not be an available option.
- Select an aggregator underneath Aggregators.
- Click + Add a new total to add any additional totals. If you want to delete a total, you can click the trash can icon next to the total.
- Click Apply.
Below is an example of a report calculating the total average number of tickets and total summation number of tickets by month
10 Comments
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?
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.
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.
@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.
Does anyone know how to just display the totals and not the rows behind the totals?
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
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)?
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.
Hello,
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 ?
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.
Cheers!
Please sign in to leave a comment.