Adding totals to results

<div class="body">
<div class="article-banners">
<div id="docs-wmp-link"><a href="https://support.zendesk.com/hc/en-us/articles/5411234991258-plan" rel="noopener" target="_blank">What's my plan?</a></div>
<div class="article-banner" id="suite_pee">
<table>
<tbody>
<tr>
<td>
<strong>All Suites</strong>
</td>
<td>Professional, Enterprise, or Enterprise Plus</td>
</tr>
</tbody>
</table>
</div>
<div class="article-banner" id="support_with_explore_pe">
<table>
<tbody>
<tr>
<td>
<strong>Support with</strong>
</td>
<td>Explore Professional or Enterprise</td>
</tr>
</tbody>
</table>
</div>
</div>
<p class="p">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 <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408846897178-Changing-metric-aggregators" target="_blank">Changing metric aggregators</a>). </p>
<div class="p">You can configure totals in two different ways in Explore:<ul class="ul" id="topic_agz_yrv_hv__ul_rmk_2fj_fbb">
<li class="li">
<strong class="ph b">Simple totals</strong> 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. </li>
<li class="li">
<strong class="ph b">Advanced totals</strong>, 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. </li>
</ul>
<div class="note note" id="topic_agz_yrv_hv__note_sh3_chr_gtb">
<span class="notetitle">Note:</span> <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408821978266" target="_blank">Applying a metric filter</a> to remove a value from being displayed in
the report doesn't exclude those values from the calculated total.</div>
</div>
<div class="p">
<strong class="ph b">To add simple totals to your report</strong><ol class="ol" id="topic_agz_yrv_hv__ol_dgm_tfj_fbb">
<li class="li">In the report builder, click the result manipulation icon (<img class="image" id="topic_agz_yrv_hv__image_jkp_gmw_hv" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" width="16">). </li>
<li class="li">Select the <strong class="ph b">Totals</strong> option. </li>
<li class="li">Underneath <strong class="ph b">Grand totals on</strong>, check the location of the attributes for which you
want to apply grand totals. You can select <strong class="ph b">Columns</strong>, <strong class="ph b">Rows</strong>, or both. </li>
<li class="li">Select an aggregator. <p class="p"><img class="image img-screenshot" id="topic_agz_yrv_hv__image_sp3_5pj_fbb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_simple_totals_select_aggregator.png" width="200"></p>
</li>
<li class="li">Underneath <strong class="ph b">Subtotals on</strong>, check the location of the attributes where you would
like to apply subtotals. You can select <strong class="ph b">Columns</strong>, <strong class="ph b">Rows</strong>, or both.</li>
<li class="li">Select an aggregator.</li>
<li class="li">When you are finished, click <strong class="ph b">Apply</strong>.</li>
</ol>
Below is an example of a report displaying the tickets solved each month and the total
number of tickets solved for the previous 12 months..</div>
<p class="p"><img class="image img-screenshot" id="topic_agz_yrv_hv__image_gr4_wpj_fbb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_simple_totals_final_report.png" width="450"></p>
<div class="p">
<strong class="ph b">To add advanced totals to your report</strong><ol class="ol" id="topic_agz_yrv_hv__ol_zzf_rgj_fbb">
<li class="li">In the report builder, click the result manipulation icon (<img class="image" id="topic_agz_yrv_hv__image_dnn_mmg_3fb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" width="16">). </li>
<li class="li">Select the <strong class="ph b">Totals</strong> option. </li>
<li class="li">Click the <strong class="ph b">Advanced</strong> tab (this is only visible if your visualization type is
<strong class="ph b">Table</strong>). </li>
<li class="li">Click <strong class="ph b">+ Add a new total</strong>. </li>
<li class="li">Underneath <strong class="ph b">Attribute</strong> select the location of the attribute you want to apply your
total to. You can calculate grand totals on either <strong class="ph b">Columns</strong> or <strong class="ph b">Rows</strong>, and
subtotals on an individual attribute. <div class="note note">
<span class="notetitle">Note:</span> You can only calculate subtotals on the first
attribute listed in <strong class="ph b">Rows</strong>. If you have an attribute in <strong class="ph b">Columns</strong> instead,
subtotals will not be an available option. </div>
<p class="p"><img class="image img-screenshot" id="topic_agz_yrv_hv__image_kyk_zpj_fbb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_advanced_totals_select%20attribute.png" width="450"></p>
</li>
<li class="li">Select an aggregator underneath <strong class="ph b">Aggregators</strong>. </li>
<li class="li">Click <strong class="ph b">+ Add a new total</strong> to add any additional totals. If you want to delete a
total, you can click the trash can icon next to the total. <p class="p"><img class="image img-screenshot" id="topic_agz_yrv_hv__image_w34_bqj_fbb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_advanced_totals_multiple_totals.png" width="450"></p>
</li>
<li class="li">Click <strong class="ph b">Apply</strong>. </li>
</ol>
</div>
<p class="p">Below is an example of a report calculating the total average number of tickets and total
summation number of tickets by month</p>
<p class="p"><img class="image img-screenshot" id="topic_agz_yrv_hv__image_vcx_hqj_fbb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_advanced_totals_final_report.png"></p>
</div>
<script id="docs-schema-markup" type="application/ld+json">{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408846476698",
"url": "https://support.zendesk.com/hc/en-us/articles/4408846476698-Adding-totals-to-results",
"headline": "Adding totals to results",
"description": "You can add simple or advanced totals to your report results using different aggregators to calculate overall totals or subtotals based on attribute locations in the report builder.",
"articleSection": "Performing calculations",
"datePublished": "2021-10-16T05:29:12+00:00",
"dateModified": "2025-09-05T23:56:24+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408846476698"
},
"author": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"publisher": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"isPartOf": {
"@type": "WebSite",
"name": "Zendesk Help",
"@id": "https://support.zendesk.com/hc/"
},
"about": {
"@type": "SoftwareApplication",
"name": "Zendesk",
"@id": "https://www.zendesk.com",
"softwareAddOn": {
"@type": "SoftwareApplication",
"name": "Explore",
"@id": "https://support.zendesk.com/hc/en-us/sections/4405298856346"
}
}
}</script>