---
id: AA-00524
title: "Filtering Data for Analysis"
url: http://netaphor.com/kb/AA-00524/filtering-data-for-analysis
product: "General"
type: "How-to & configuration"
updated: 2012-11-17
access: public
---


# Filtering Data for Analysis

Filtering data enables you to create special reports and fleet metrics for cost and service management. For example, you can determine the 25 most problematic printers, the monthly color print volume for HP color LaserJets, or estimate the number of help desk calls by month.

## Viewer Basics

Filtering is just one way to customize the standard views of data, and you can use it in conjunction with other ways. Before you understand filtering, you should understand the standard views and how you can modify their display.

The standard views are available on the **View** menu and the toolbar.

![](http://netaphor.com/kb/media/AA-00524/filtering-viewmenu.jpg)

![](http://netaphor.com/kb/media/AA-00524/filtering-viewstoolbar.jpg)

Also on the toolbar, you can adjust the time span for which SiteAudit displays data.

![](http://netaphor.com/kb/media/AA-00524/filtering-timespan2.jpg)

In the information grid, you can add and remove columns, change the order of columns, change the width of columns, and group and sort data by column.

### Example: Group by manufacturer

Grouping inventory by manufacturer tells how many printers are HP, Canon, Lexmark, Xerox, etc.

Drag the **Manufacturer** column heading to the Group By box above it.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupbycolumn.jpg)

The information grid now shows how many printers there are from each manufacturer.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupedbymanufacturer.jpg)

Expand a manufacturer to see individual printers.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupedbymanufacturer2.jpg)

### Example: Display color printers sorted by manufacturer

Drag the **Output** column heading to the Group By box.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupedbyoutput.jpg)

Expand the color printers.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupedbyoutput2.jpg)

Click the **Manufacturer** column heading to sort alphabetically by manufacturer.

![](http://netaphor.com/kb/media/AA-00524/filtering-groupedbyoutput3.jpg)

## Creating a Basic Filter

You can create a basic filter for any column of data.

1. Pause the cursor over the column heading until a funnel appears.

![](http://netaphor.com/kb/media/AA-00524/filtering-filter-01.jpg)

1. Click the funnel, and click **(Custom)**.

![](http://netaphor.com/kb/media/AA-00524/filtering-filter-02.jpg)

1. In the **Custom AutoFilter** dialog box, enter the conditions for your filter, and click **OK**.

### Example: Specific manufacturers

1. Filter the **Manufacturer** column, and show only those rows where the value of the column equals **Brother** or equals **Hewlett-Packard**.

![](http://netaphor.com/kb/media/AA-00524/filtering-filter-03.jpg)

1. Click **OK** to apply the filter to the information grid.

![](http://netaphor.com/kb/media/AA-00524/filtering-filter-04.jpg)

Because you can express AutoFilter conditions in many ways, including **equals**, **does not equal**, **is greater than**, and **is less than**, you have great flexibility in creating filters.

![](http://netaphor.com/kb/media/AA-00524/filtering-filter-05-conditions.jpg)

## Creating a Complex Filter

Whereas a basic filter operates on a single column, a complex filter provides a way to mine or view a combination of columns to show data about the cost and performance of the printer fleet.

The best approach to using complex filters, which will save time constructing them, is to write out by hand the columns to be mined. Then, find the view that makes those columns available.

### Example: Problematic printers from MFP manufacturers

The metric that interests you is critical errors and downtime for printers from MFP manufacturers. The **Problem Analysis** view makes available the columns **Manufacturer**, **Critical Errors**, **Pages Printed**, and **Downtime**.

1. With the Problem Analysis view displayed, click the **Edit Filter** button at the bottom right.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-01.jpg)

1. Click the plus sign to add a condition.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-02.jpg)

1. Click **Asset tag**, and in the list that appears, click **Critical Errors/Pages Printed**.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-03.jpg)

1. Click **Equals**, and in the list that appears, click **Is greater than or equal to**.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-04.jpg)

1. Click **\<Enter a value\>**, and in the box that appears, type your threshold for the ratio of critical errors to pages printed.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-05.jpg)

1. Click the plus sign again, and edit the new condition.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-06.jpg)

1. Click **And**, and add a group of conditions.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-07.jpg)

1. Click the new **And**, and change it to **Or**, because the next condition includes *any* of a list of manufacturers (this one *or* that one).

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-08.jpg)

1. For each condition you want to include in the filter, click the plus sign again, and edit the condition.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-09.jpg)

1. This filter will show all printers from five MFP makers with downtime greater than one day, with an error frequency greater than 1% while printing at least 100 pages during the month. These are the problem printers.

### Example: Volume analysis metric defined by the minimum number of color and B/W pages

![](http://netaphor.com/kb/media/AA-00524/filter2.jpg)

This filter from the **Volume Analysis** view shows the color and B/W output from color printers. It answers the question whether color printers are used for color only or a mix of color and B/W. Because color printers cost more and per-print cost is greater, this is useful for controlling costs.

**Example: Estimated Help Desk Calls defined by severity, duration, training level and description**

![](http://netaphor.com/kb/media/AA-00524/filter1.jpg)

This filter from the **Incident History** view shows the number of critical incidents over 30 minutes in duration that require a trained person and do not concern toner. (It is assumed toner is changed without help desk intervention.)

SiteAudit’s notification capability allows incident information to be automatically emailed to help desk, service and administrator people. The benefit of SiteAudit’s rules-based notification capability is higher employee productivity as printers have better uptime performance. Knowing how to use filters is applicable to creating notification rules and conditions; both use the same logic.

## Reports

You can use filters to create custom reports, such as a report that shows the top problem printers. Once the filter is applied to a view, click Print Preview on the File menu. (See Making Custom Reports.)

## Reusing Filters

You can reuse complex filters. For example, you can use the Top Problem Printers filter to generate a report each month.

1. Click the arrow at the bottom left part of the information grid.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-10.jpg)

1. Click the filter that you want to apply.

![](http://netaphor.com/kb/media/AA-00524/filtering-complex-12.jpg)

You can modify the filter by clicking the **Edit Filter** button and changing the conditions.