KnowledgeBase - How do I filter the contents reports based on more than one criteria?
Article

How do I filter the contents reports based on more than one criteria?

« Go Back
Products
Webtrends Legacy Products
Question
How do I filter the contents reports based on more than one criteria?
Answer
For products:
Webtrends Enterprise 7.x
Webtrends Professional 7.x
Webtrends Small Business 7.x
Webtrends Log Analyzer Advanced 8.0x
Webtrends Log Analyzer 8.0x
Webtrends Reporting Center 6.0x

Last modified: 10/28/2010

Introduction:
A filter is a setting in the profile which is used to narrow the scope of a report or view by specifying ranges or types of data from the log file to include or exclude. One filter with multiple elements is an "And" filter, while several filters of the same type are "Or" filters. But do not be confused with multiple entries in one filter field. The following examples will further illustrate this idea.

"And" Filters: Single Include/Exclude Filters with Multiple Elements
Several filter elements can be combined into one include or exclude filter. Multiple elements are processed with Boolean "And" logic; the criteria of every element must be met for the log record to be included or excluded.

First example:
Below is one example of an "And" filter (one filter with many elements). Let us say that you want to determine if a specific user (janesmith.com) viewed a particular directory (/Sales) of your web site. Create an include filter by selecting User Address or Country and Directory, and then by entering the following criteria: User Address or Country: janesmith.com Directory: /Sales If a log record is found containing both of the criteria specified, the entry is included in the report. The filter summary dialog lists everything defined for the current filter. If multiple filter elements are used in one filter it is always a good idea to check the summary tab to review the elements selected. Note: This summary dialog is not available in Webtrends Reporting Center. Remember, if a profile contains a single include or exclude filter with one or more elements, activity that matches the criteria of all elements of that filter is included or excluded in the report.

Second example:
To create a report that examines activity by a specific group of users (i.e., internal users to your organization and your domain is 10.1.1.*) who access a specific file type (.html), create an include filter with the following elements: User Address or Country: 10.1.1.* File Only: *.html

If user 10.1.1.6 accesses the file index.asp, the record in the log file of this activity is not included in the report because 10.1.1.6 did not access an HTML file type.

If user 126.14.8.1 accesses page.htm, the record in the log file of this activity is not included in the report because the user address is not part of the specified range.


If user 10.1.1.6 accesses page.htm, the record in the log file containing this activity is included because both criteria are met.

Third Example:
To create a report that examines all activity except that by a specific group of users (users internal to your organization with the domain 10.1.1.*) who access a specific file type (.html), create an exclude .filter with the following elements: User Address or Country: 10.1.1.* File Only: *.html

If user 10.1.1.6 accesses the file, index.asp, the record of that activity in the log file is included in the report because 10.1.1.6 did not access an HTML file. Both criteria must be met to be excluded.

If user 126.14.8.1 accesses page.html, the record is included in the report because the user address is not in the excluded range.

If user 10.1.1.6 accesses page.html, the record is not included because it meets the criteria of both elements.

"Or" Filters: Multiple Include/Exclude Filters with Single Elements
If a profile contains several include or exclude filters, each having one or more elements, activity that matches the criteria of all of the elements of any one of the filters is included in the report. The application reads multiple filters of the same type in a profile as an "Or" statement. If a log file record matches Filter1 or matches Filter2 then the log file record is included or excluded the data in the report.

First example:
Filter 1: Exclude user address 206.58.83.196 and exclude referrer www.domain.com. This will exclude all activity from the user address 206.58.83.196 when that user address was referred from www.domain.com. It will include that user address when it was referred from any other domain. It will also include activity from users other than 206.58.83.196 even when they have been referred by www.domain.com.


Second example:
Filter 1: Exclude user address 206.58.83.196.

Filter 2: Exclude referrer www.domain.com. This will exclude all user addresses from 206.58.83.196 regardless of the referrer. Similarly, it will exclude all activity from users that were referred from www.domain.com, regardless of their user address. If 206.58.83.196 is referred from www.domain.com, the log file record is still excluded.


Third example:
Elements in a single field of a single filter (a space is used to separate each element) are still considered to be "Or" statements.

Filter 1: Exclude User Address or Country 206.58.24.8 206.58.83.196 This will exclude activity from either of the two addresses.
Information
 
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255