How to remove Not Specified values from metrics totals | Community
Skip to main content
K
kbutterly
Level 2
October 16, 2015
Solved

How to remove Not Specified values from metrics totals

  • October 16, 2015
  • 3 replies
  • 1271 views

Hi,

I have a Entry Page - Search Engine report (Entry Pages broken down by Search Engines-All)

Output looks like this, metric is Visits

PageName                    4,000

    Unspecified                2,500

    Google                        1,000

    Yahoo                           300

I can filter out the row Unspecified, but the Total for PageName still includes the total for Unspecified.  What I want is

PageName                   1,500

    Google                        1,000

    Yahoo                           300

How do I do that?  I may be going at this all wrong...

Thanks,

Kathryn

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TanmayMathur

Hi Kathryn,

Using a filter will not affect the total number in this case. If you want to the total to show only the sum of the included line items you should create a segment with the same logic and apply it on the report. You should get the required result then.

Let me know if that works.

TM

3 replies

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
October 16, 2015

Hi Kathryn,

You can do that by clicking on 'Advanced' against the filter option. Select 'If all criteria are met' then under the rule select 'Does not contain' and type in 'Unspecified' and run the report. It will not contain the total for that line item.

Let me know if it solves your query.

TM

K
kbutterlyAuthor
Level 2
October 16, 2015

Hi,

If I am understanding you, I think I did that.  Next to the filter box, I clicked advanced.  Then for Search Engines dimension, I selected Does Not Contain None.

"unspecified" no longer appears in the list of Search Engines, but the total of 'unspecified' still is included in the first dimension (Page) total.

 

Using the example I gave above, this is what I get as a result.  PageName still has a value that includes the total for 'unspecifiedl

PageName                    4,000

    Google                        1,000

    Yahoo                           300

 

Thanks,

Kathryn

TanmayMathur
Adobe Employee
TanmayMathurAdobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

Hi Kathryn,

Using a filter will not affect the total number in this case. If you want to the total to show only the sum of the included line items you should create a segment with the same logic and apply it on the report. You should get the required result then.

Let me know if that works.

TM

Terms & ConditionsAccessibility statement

Loading footer...