In Explore, you can find the total of your overall results or subtotals for individual categories in a report. 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 report.
- Advanced totals, usable only with the Table visualization option, let you to add multiple rows of totals, each with a different aggregator. Grand totals will be applied only to the first attribute on the selected location. Subtotals are available only for the first attribute on rows. If you have attributes on columns, subtotals will not be an available action.
Note: Applying a metric filter to remove a value from being displayed in
the report doesn't exclude those values from the calculated total.
To add simple totals to your report
- In the report 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 report
- In the report 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
32 comments
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?
2
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.
0
Brandon (729)
Hey @... -
Sorry for the delay here. You can use the advanced sort feature under results manipulation to keep that sum in place!

-1
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?
0
Brandon (729)
Hi @...,
There's a couple ways you can do this, but the easiest might be custom metrics... something along the lines of:
MyCustomMetric:
IF ([CUSTOM_FIELD_NAME] = "CES") THEN
[Ticket ID]
ENDIF
MyCalculation
SUM(MyCustomMetric)/DCOUNT_VALUES([Update ID])
You could also do a Result Path Calculation and then hide part of your result to get it back into KPI format.
Hope this points you in the right direction!
Brandon
0
Matt Farrington-Smith
Hey @... how would I do the following (relatively simple I guess, but am struggling!)

I have a custom metric that calculates handling time - what I want is to show that figure as a percentage of total possible hrs worked (let's say 354). How do I do this?
Cheers for any pointers!
Matt
0
Brandon (729)
Hey @... -
Nice to hear from you! In this case, you'd use a second custom metric that is just
[Update Handing Time (Hrs)] / 354
Then, use the paintbrush to change your display format to a %.
Hope this helps!
Brandon
1
Matt Farrington-Smith
@... appreciate the help here!
I had problems at first, but then changed the formatting slightly:
SUM(Update handling time (hrs)) / 354
Cheers sir
1
Casey
Hi Zendesk - Having an issue where "simple" sum totals aren't showing for all rows. In the screen below, it appears only "Tickets reopened" is showing under Ticket totals for each row(s). Any suggestions? Thanks!
0
Dylan Tragjasi
I'm not entirely sure how the "Ticket totals" row is being calculated in your screenshot - I presume this is a result path calculation, which might be why it's not working correctly as a total/sum aggregator for the metrics in your query.
At any rate, you can only calculate subtotals using the native "simply" sum total feature if you have multiple attributes in use in your query. I have attached a screenshot demonstrating how this could work with a similar example to the one you're working on.
I hope this helps clarify!
Thanks,
Dylan
0
Casey
Thank you @... for the additional information. Below is the query I based the previous one off of, only using "Tickets created" rather than "Tickets updated w/ comment". In this case, the rows are totaling correctly. Is there something I need to do in the result path calculation you mentioned to make "Tickets updated w/ comment" behave in the same manner?
0
Dylan Tragjasi
Thanks,
Dylan
0
Trevor Kanaya
Hi all,
I'm adding grand totals on rows but the aggregator should use AVG instead of SUM. When I do this, there's no way to keep the aggregated numbers pinned to the top or bottom of the table. In other words, with SUM, the value of the grand total row will always be highest so it's easy to sort high to low, but an average would fall somewhere in the middle obviously.
So, is there any way to keep an AVG row at top or bottom? It seems a bit unlikely that a user would want it anywhere other than top or bottom, frankly.
1
Gab Guinto
If you're manually sorting the values by clicking on the metric column header, then the rows containing the totals (SUM/AVG) will also be included. You might want to sort via Result manipulation → Sorts if you need want the keep the totals in their original position/row. Here's an article about Sorting results.
0
Allen Eickelberg
Is it possible to create metrics that can run further calculations on a grand total in a report?
Here's the scenario; I've used time tracking and written metrics to sum total time for tickets; then round that time to 15 minute blocks. The grand total in 15 minute blocks at the bottom I want to use a metric to multiply that by a billable hourly equation that bills the greater of a minimum number of time blocks or the actual number of time blocks.
If I can write metrics off of the "grand total" I can use explore to essentially automate and produce invoices for our billable time.
0
Phaedon
When adding a total to a table it seems as if the aggregator is being used on the row data rather than the background data. Is there a way to fix this?
Specifically, I'm looking at a table of first reply (AVG) time by agent and month. When I add a Grand Total, with the AVG aggregator, it seems to take an average of the individual lines rather than an average of the total data. It's doing an average of the averages rather than the overall first reply time for that month. How might I change that?
0
Dane
The TOTALs result manipulation will only count the data on the actual row or column. It will not parse the data on each row (hence resulting to what you have mentioned calculating the average of the average). The only way for it to match the main results given by AVE First Reply time is to add the attribute Ticket ID that will let the data for each agent to be counted individually.
0
Phaedon
Thanks for that feedback Dane! Can you give me some guidance to how to do what you're describing with the attribute Ticket ID or point me to an article that will show me? I'm quite new at all this.
0
Dane
You will have to add Ticket ID as an attribute.
This is the original FRT.
FRT when you used total with Assignee name attribute.
Original FRT result was extracted when you add the attribute Ticket ID.
0
Phaedon
Thank you so much Dane! I see what you mean now.
Last question though: is there a way to do this, but not actually show the Ticket IDs as rows? I'd love to have the overall average, and the average by assignee, without the per ticket detail, in one table.
0
Dane
0
Phaedon
Hi Dane,
Thanks for the feedback. That's really a shame. It would be so nice to be able to show the overall average and the agent average in a single table...
0
Kateryna Sikorska
Hi Team, The Totals seems to be only visible in a Table format, is it possible to see them using Column or Line Visualisation type?
0
Dane
The column total will add another column on your report that shows the total of all the data.
0
Ofer Rozen
Hello,
I created a report of created and solved tickets since January of a specific customer and added a total (sum) of both metrics. The chart currently shows that bars with all created and solved in the last months but I just want to show to the results of the total created and solved. How to do I just show the total results?
0
Zsa Trias
Hello Ofer,
If you only need to view the totals and not the values for each date, you can drag the "Update - Date" attribute to the tap bar so it would be used as a filter and not a column in the report.
0
D.Fitz
Is there any way to add the 'Total' as a percentage while leaving the remaining values as numbers?
0
bill cicchetti
How can I get the percentages highlighted in yellow to be based on the sums of the two columns instead of the sum of the percentages above it?
0
bill cicchetti
I actually figured this out. I used the "Result Metric Calculation" to get the desired results
0
Elaine
That's good to hear! By using this sample formula you may use the Result Metric Calculation to create a total percentage. Here's an article for reference.
0