The overall sum remains consistent in Zendesk Explore reports with top/bottom filters because the filter only hides results, not excludes them.
When you apply a top/bottom filter, it allows you to focus on the highest or lowest results within your report based on a specific range you define. However, even though the filter hides the results that don’t match your criteria, those hidden results are still included in the report’s data. Therefore, when you add a total to a report that uses a top/bottom filter, the sum of the values remains constant. The total sum calculation considers all results, whether they’re visible or hidden, to show the overall total. For more details, you can check theoriginal article.
Top/bottom filters in Zendesk Explore affect data visibility by hiding certain results but not excluding them from the total calculation. These filters allow you to focus on the highest or lowest results within your report based on a specific range…
The purpose of using top/bottom filters in Zendesk Explore is to focus on specific data ranges while maintaining the integrity of the overall dataset. These filters are designed to help you concentrate on the highest or lowest results within your…
Including hidden results in the overall sum is important for maintaining data integrity and reliability in Zendesk Explore. When using top/bottom filters, the hidden results are still part of the dataset, ensuring that the total sum reflects all…