Filtered Totals | Community
Skip to main content
zergle
Level 2
Mar 9, 2010 5:51 AM UTC
Investigating

Filtered Totals

When applying any type of filter to a report or view, there should be a sub total and a total provided.  So if the grand total is 1,000 and we filter out items that are worth 100, then we should see a sub-total or filtered total of 900 as well as a grand total of 1,000.  The percentages of each item should be impacted the same way.  % of grand total and % of sub total. This should be available on every report and every metric.

8 replies

Level 2
Jul 23, 2018 10:40 AM UTC

Total is actually hugely important; it's the only way to get deduped counts in Adobe Analytics.   As soon as you do a Unique Visitor (aka Unique User) count of any kind, you quickly discover that in many cases, UU cannot be and should not summed; the only deduped count is that little "total".  Yes, it's misleading, it's undocumented, it's calcs are not clearly defined on the screen, even why it appears sometimes and not others, all true... and all good reasons to fix this, initially for total, then later with a subtotal approach per parent request.

Translate
Level 5
Jul 23, 2018 7:50 AM UTC

It should be always clear which "total" is displayed: it is not the same behavior when filtering the data and when segmenting  the data! Many users are confused and do not know what "total" means in the current context.

Translate
Level 2
Apr 15, 2014 1:18 AM UTC

Hope Adobe changes their opinion and gets this implemented. This is a major drawback of discover when it comes to analysis.

Translate
Level 4
Feb 6, 2012 6:34 AM UTC

This has been under review for almost 2 years. It makes discover practically unusable, that one has to pull entire sets of data (often up to the uniques allowed) and sum them over in excel every time. It's ridiculous we have to bounce back and forth between Discover and SiteCatalyst.

Translate
jmartinnxtbook
Level 2
Sep 13, 2010 7:13 AM UTC

I would like the option to remove total, as it is confusing when they see a total that doesn't match what the filter result is showing

Translate
Matt_Freestone
Employee
Apr 2, 2010 2:43 PM UTC
Translate
robmorrow
Level 2
Mar 31, 2010 9:06 AM UTC

I would also recommend that for certain reports like the Site Content >> Site Sections Report that when this report's metrics are set to Visits or Unique Visitors that the total is removed since totalling Visits or Visitors is not accurate. Any Visitors who visit multiple Site Sections will count as a Unique Visitor in each, but only count once in the total. An in-product  explanation could possibly be used and replace the Total display.

Translate
jujuvarnum
Level 2
Mar 10, 2010 2:48 PM UTC

and those totals and substotals must be enabled for all metrics that are on the "add metrics"

Translate