The Data Analysis Tool (Reports > Data Analysis) is an open system used to create reports and graphical summaries designed for a specific task based on categorization of the data. It is useful for creating unusual reports, for example “average ozone value on Tuesdays”. First select Start and End dates Site/Parameter(s), and an Average Interval. The Data Analysis Tool is more useful for looking at a single parameter at a time (for one or more sites), for example, ozone for the month of August. After selecting the data range, click the Generate Report button on the ribbon at the top of the screen (Figure 4-12).


Figure 4-12 Data Analysis Tool from Reports menu

After you generate the report, you can minimize the Report Criteria pane to make more space for the Report Output section by clicking the minus sign. Notice the gray field Drop Filter Fields Here. Default filters are Site, Parameter, and Report Value (Average). To add more Filter Fields, right-click in Drop Filter Fields area and select Show Field List. (or click Show Column Choose on the ribbon at the top of the screen .From the pop-up list you can either select and click the Add to Filter Area button, or click-drag to the Drag Filter Fields Here area (Figure 4-13).


Figure 4-13 Data Analysis Tool with pop-up Filter Field List (Reports menu)

After you drag a new Filter Field to the Drop Filter Fields Here area (which is a “holding” area where fields are not active but available for immediate reactivation) the new field will not be activated until you drag it to the column area (Figure 4-14). After that the new field information will be displayed. The screen shot below shows the new Filter Field Week Day Name. Scroll to the bottom of the report to see Totals.

If you select Week Day instead of Week Day Name, you will get a numerically ordered display. To remove a header, right-click the header and select Hide. To move a header back to the inactive area, click and drag it.


Figure 4-14 Data Analysis Tool with new Filter Field (in this example,Week Day Name) dragged to column area (Reports menu)

Figure 4-15 illustrates a grid with Hour selected as a new Filter Field. Since the grid can be large, you could drag the Date field up the Drag Filter Fields Here area and deactivate the Date column (Figure 4-16).


Figure 4-15 Data Analysis Tool with Hour added as a new Filter Field (Reports menu)



Figure 4-16 Data Analysis Tool with the Date column deactivated (Reports menu)


In these examples, only one Interval was selected (001h), so you could simplify the grid further by deactivating the Interval column, i.e., drag it to the Drop Filter Fields Here area (Figure 4-17).


Figure 4-17 Data Analysis Tool with the Date and Interval columns deactivated (Reports menu)


If you deactivate the Interval column (by dragging it to the Drop Filter Fields Here area), you an control how rows are displayed. For example, you could drag the Hour field into the Drag Row Fields Here area and the Week Day Name back into the column area (Figure 4-18).


Figure 4-18 Data Analysis Tool with the Date and Interval columns deactivated, Hour dragged into Drag Row Fields area, and Week Day Name moved back into the column area (Reports menu)


Figure 4-19 shows composite statistics for a month, broken down by hour and day of the week, but you can combine data for more than one site by using filters to break down data into different categories. If you move Site back to the “holding” area, the filter will be removed and data will be grouped together, which means you won’t have to scroll to see a second site. Similarly, multiple parameters could be grouped or merged, for example when ozone parameters
goes by different names.


Figure 4-19 Data Analysis Tool with the Date and Interval columns deactivated, Hour dragged into Drag Row Fields area, Week Day Name moved back into the column area, and Site moved into “holding” area (Reports menu)

You can manipulate the way data is displayed in Data Analysis Report further as follows:

• With the cursor over a Filter name, click the small up or down arrow to change the sort order of that Filter (Figure 4-20).

Figure 4-20 Filter name showing arrow and filter icon

• Hover the cursor over a Filter name and click the small filter icon that appears in the upper right corner. to open a pop-up list of each aspect of the Filter (Figure 4- 21) In this example, you could remove weekend days from analysis; if Hour was selected as a filter, you could toggle settings to include only commuting hours.

If you left-click .Report Value, you can select from the following options: Count, Sum, Min, Max, Average (the default), StdDev, StdDevp, Var, Varp, and Custom. Changing this selection can be helpful for answering questions like “What is the highest value for Monday, 9 a.m. for the entire year?”

Figure 4-21 Display names for Week Day Name

Saving Grid Layouts as Favorites:

The Favorites editor only saves the data query itself, not the changes in filters. To save an analysis layout, click Save Grid Layout or Apply Grid Layout on the ribbon at the top of the screen (Figure 4-22).



Figure 4-22 Save Grid Layout and Apply Grid Layout buttons in the ribbon at the top of the Data Analysis Report screen


Chart Display

To display the data analysis report as a chart, click the Show Chart button in the ribbon at the top of the page and select a row, column, or range of cells. Figure 4-23 shows a Point graph by Hour.

The Bar graph (shown earlier in Figure 4-11) is generally well-suited for any data selection.


Figure 4-23 Data Analysis report displaying data as a Point graph