Understanding Explore product limits

<body>
<p id="docs-hc-snippet" style="display: none;">This article details the product limits that are in place for Explore. As more product limits are added to Explore, this article will continue to be updated. To ensure that you’re kept up to date on all changes, click Follow at the top of this article.</p>
<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_all">
<table>
<tbody>
<tr>
<td>
<strong>All Suites</strong>
</td>
<td>Team, Growth, Professional, Enterprise, or Enterprise Plus</td>
</tr>
</tbody>
</table>
</div>

<div class="article-banner" id="support_with_explore_all">
<table>
<tbody>
<tr>
<td>
<strong>Support with</strong>
</td>
<td>Explore Light, Professional, or Enterprise</td>
</tr>
</tbody>
</table>
</div>

</div>
<div id="docs-ai-summary">
<p id="docs-ai-summary-toggle">Verified AI summary <span id="up-triangle">◀</span><span id="down-triangle">▼</span></p>
<p id="docs-ai-summary-content">Explore product limits help you manage report and dashboard performance. For reports, strict limits include a 2-minute loading timeout and a 50,000-row cap. Recommended limits suggest keeping metrics and attributes under 40. For dashboards, strict limits include 100 live dashboards per account and a 20 MB email attachment cap. Recommended limits suggest up to 10 tabs per dashboard and 35 components per tab.</p>
</div>

<div class="body">

<p class="p">This article details the product limits that are in place for Explore. As more product
limits are added to Explore, this article will continue to be updated. To ensure that
you’re kept up to date on all changes, click Follow at the top of this article. </p>
<p class="p">This article covers the following topics: </p>
<ul class="ul" id="explore_product_limits__ul_jvq_njz_nvb">
<li class="li"><a class="xref" href="#topic_sh5_ljz_nvb">Limits for reports</a></li>
<li class="li"><a class="xref" href="#topic_nj4_rjz_nvb">Limits for dashboards</a></li>
</ul>
</div>
<div aria-labelledby="ariaid-title2" class="topic nested1" id="topic_sh5_ljz_nvb">
<h2 class="title topictitle2" id="ariaid-title2">Limits for reports</h2>
<div class="body">
<p class="p">The following tables show the maximum strict and recommended limits for Explore
reports.</p>
</div>
<div aria-labelledby="ariaid-title3" class="topic nested2" id="topic_jcs_lpm_vwb">
<h3 class="title topictitle3" id="ariaid-title3">Strict limits</h3>
<div class="body">
<p class="p">Strict limits are enforced by Explore and cannot be overridden by the user.</p>
<div class="p">
<div class="tablenoborder">
<table border="1" cellpadding="4" cellspacing="0" class="table" frame="border" id="topic_jcs_lpm_vwb__table_qbr_q21_4vb" rules="all" summary="">
<colgroup>
<col>
<col>
</colgroup>
<tbody class="tbody">
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Item</strong></td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Maximum</strong></td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Loading timeout</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">2 minutes<p class="p">The more complex a report is, the
longer it takes to load. If a report cannot be loaded
within 2 minutes, its execution is canceled.</p>
</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Rows </td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">50,000 <p class="p" dir="ltr">If a report has more than
50,000 rows, results are truncated at the first 50,000
rows. </p>
<p class="p" dir="ltr">Rows that are processed as part
of a <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408845804314" target="_blank">formula</a> also
count toward this limit. As a result, reports with
complex formulas might encounter this limit even if the
final report has fewer than 50,000 rows.</p>
<p class="p">When you
export report data, the export is restricted to a
maximum of 50,000 rows. However, the overall size of the
report data can also affect the export process. If an
export fails despite remaining within the limit of
50,000 rows, consider reducing the number of attributes
or applying additional filters to decrease the total row
count.</p>
</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Explosions</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">30</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Attributes within each drill in level</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">20</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">SQL query length (Calculation
complexity)</td>
<td class="entry cell-norowborder" style="vertical-align:top;">
<p class="p" dir="ltr">1 million characters</p>
<p class="p" dir="ltr">If your report’s calculations are too complex,
the following message appears: “Calculations are too
complex. Simplify calculated metrics and attributes or
remove some of them.” This limit is reached when the
underlying SQL query generated for the report has more
than 1 million characters.</p>
</td>
</tr>
<tr class="row">
<td class="entry row-nocellborder" dir="ltr" style="vertical-align:top;">Nested calculations</td>
<td class="entry cellrowborder" dir="ltr" style="vertical-align:top;">3 levels</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div aria-labelledby="ariaid-title4" class="topic nested2" id="topic_k2s_sbh_vwb">
<h3 class="title topictitle3" id="ariaid-title4">Recommended limits</h3>
<div class="body">
<p class="p">Zendesk cannot guarantee reports will be successfully executed if they are in
breach of the following recommended limits.</p>
<div class="p">
<div class="tablenoborder">
<table border="1" cellpadding="4" cellspacing="0" class="table" frame="border" id="topic_k2s_sbh_vwb__table_xl4_cch_vwb" rules="all" summary="">
<colgroup>
<col>
<col>
</colgroup>
<tbody class="tbody">
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Item</strong></td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Maximum</strong></td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Columns</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">
<p class="p" dir="ltr">Visualizations have different column
limits:</p>
<ul class="ul" id="topic_k2s_sbh_vwb__ul_y1p_3ch_vwb">
<li class="li" dir="ltr">
<p class="p" dir="ltr">100: Pie, Funnel, Bullet, Gauge, Picto,
Radar, Parallel sets</p>
</li>
<li class="li" dir="ltr">
<p class="p" dir="ltr">500: Table, Word cloud</p>
</li>
<li class="li" dir="ltr">
<p class="p" dir="ltr">1,000: Auto, Treemap, Relational,
Sunburst, Sparkline, Dot</p>
</li>
<li class="li" dir="ltr">
<p class="p" dir="ltr">3,000: Area, Column, Line, KPI, Bubble,
Waterfall</p>
</li>
</ul>
</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Metrics and attributes </td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">
<p class="p" dir="ltr">40 </p>
<p class="p" dir="ltr">This is the maximum number of combined metrics
and attributes that can be added to a report. For
example, a report can have 10 metrics and 30
attributes.</p>
</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Filters</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">10</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Nested calculated attributes</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">Nesting calculated attributes inside of other
calculated attributes or metrics is not recommended. Doing
so exponentially increases the complexity of the report,
resulting in potentially poor performance.</td>
</tr>
<tr class="row">
<td class="entry row-nocellborder" dir="ltr" style="vertical-align:top;">Conditions per formula or calculation</td>
<td class="entry cellrowborder" dir="ltr" style="vertical-align:top;">200<p class="p">This is the maximum recommended number of
conditions that can be added to formulas or used in
UI-based calculations (like <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408836227866" target="_blank">groups and
sets</a>).</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<div aria-labelledby="ariaid-title5" class="topic nested1" id="topic_nj4_rjz_nvb">
<h2 class="title topictitle2" id="ariaid-title5">Limits for dashboards</h2>
<div class="body">
<p class="p">The following table shows the maximum strict and recommended limits for Explore
dashboards.</p>
</div>
<div aria-labelledby="ariaid-title6" class="topic nested2" id="topic_ent_gcp_tyb">
<h3 class="title topictitle3" id="ariaid-title6">Strict limits</h3>
<div class="body">
<p class="p">Strict limits are programmatically enforced by Explore and cannot be overridden
by the user.</p>
<div class="p">
<div class="tablenoborder">
<table border="1" cellpadding="4" cellspacing="0" class="table" frame="border" id="topic_ent_gcp_tyb__table_qfq_1f1_4vb" rules="all" summary="">
<colgroup>
<col>
<col>
</colgroup>
<tbody class="tbody">
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Item</strong></td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Maximum</strong></td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Live dashboards open per account </td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">100 <p class="p">See <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408846310810" target="_blank">Live data limits for
Explore dashboards</a>.</p>
</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Applied filters on a live dashboard</td>
<td class="entry cell-norowborder" style="vertical-align:top;">5 attribute values per filter</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Scheduled deliveries email attachments</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">20 MB</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Scheduled deliveries timeout</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">20 minutes</td>
</tr>
<tr class="row">
<td class="entry row-nocellborder" style="vertical-align:top;">Dashboard restrictions</td>
<td class="entry cellrowborder" style="vertical-align:top;">
<ul class="ul" id="topic_ent_gcp_tyb__ul_v2r_p1l_5xb">
<li class="li">10 for Professional plans</li>
<li class="li">500 for Enterprise plans</li>
</ul>
<p class="p">See <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/5282695803290" target="_blank">Dynamically adapting
dashboard data based on viewer</a>. </p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div aria-labelledby="ariaid-title7" class="topic nested2" id="topic_yql_kcp_tyb">
<h3 class="title topictitle3" id="ariaid-title7">Recommended limits</h3>
<div class="body">
<p class="p">Zendesk cannot guarantee dashboards will load successfully if they are in breach
of the following recommended limits.</p>
<div class="p">
<div class="tablenoborder">
<table border="1" cellpadding="4" cellspacing="0" class="table" frame="border" id="topic_yql_kcp_tyb__table_yxl_mcp_tyb" rules="all" summary="">
<colgroup>
<col>
<col>
</colgroup>
<tbody class="tbody">
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Item</strong></td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;"><strong class="ph b">Maximum</strong></td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" dir="ltr" style="vertical-align:top;">Tabs per dashboard</td>
<td class="entry cell-norowborder" dir="ltr" style="vertical-align:top;">10</td>
</tr>
<tr class="row">
<td class="entry row-nocellborder" dir="ltr" style="vertical-align:top;">Components per tab</td>
<td class="entry cellrowborder" dir="ltr" style="vertical-align:top;">35</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<script id="ai-summary-script">
//<![CDATA[
const ai_summary_style = document.createElement('style');
ai_summary_style.innerHTML = `#styled-article-body{padding:0 0 0}#article-body #docs-ai-summary{background-color:#f3f3f3;border:1px solid #d3d3d3;padding:10px 10px 6px;margin-bottom:16px}#article-body #docs-ai-summary #docs-ai-summary-toggle{font-size:.9em;font-weight:700;margin-bottom:4px;cursor:pointer;display:flex;justify-content:space-between;align-items:center}#article-body #docs-ai-summary #docs-ai-summary-toggle #up-triangle{margin-left:auto;padding-right:10px;display:none}#article-body #docs-ai-summary #docs-ai-summary-toggle #down-triangle{margin-left:auto;padding-right:10px}#article-body #docs-ai-summary #docs-ai-summary-content{font-size:.9em;padding-left:25px;padding-right:25px;margin-bottom:12px}`;
document.head.appendChild(ai_summary_style);

const toggleAISummary = () => {
const summary = document.getElementById("docs-ai-summary-content");
const upTriangle = document.getElementById("up-triangle");
const downTriangle = document.getElementById("down-triangle");
if (summary.style.display === "none") {
summary.style.display = "block";
upTriangle.style.display = "none";
downTriangle.style.display = "inline";
} else {
summary.style.display = "none";
upTriangle.style.display = "inline";
downTriangle.style.display = "none";
}
};

document.getElementById("docs-ai-summary-toggle").addEventListener("click", toggleAISummary);
//]]>
</script>
</body>