Chat now with support
Chat with Support

MessageStats 7.8 - Reports User Guide

Viewing, Creating, and Editing MessageStats Reports My Reports and Corporate Reports Exchange Executive Summaries Reports Exchange Organizations Reports Exchange Server Reports Exchange Content Analysis Reports Exchange Mailboxes Reports Exchange Mail Contacts Reports Exchange Distribution Groups Reports Exchange Public Folders Reports Exchange Storage Reports Exchange Internet Reports Exchange Inventory Reports Migration Reports MessageStats Gathering Reports Appendix A: How to Read the Reports Report Filter Definitions

Using the MessageStats Graph Wizard

The Graph Wizard consists of several pages. Primarily you select the graph type, the data source, and the fields that are used to create the graph. You do not have to access the pages in order. To access a specific page, select it on the list of pages on the left side of the Graph Wizard.

To create a custom graph, you can select the following options:

•
Datasource
•
Graph Type
•
Fields
•
Filter
•
Sort
•
Format
•
Description

For date-based data sources, you must select a filter to limit the date range (or leave the default value). You set a filter for date-based data sources to improve performance when creating a graph.

Determining Which Data Sources You Want

If you are creating a graph that is similar to a graph in one of the standard reports, you can view the data sources for the standard report and incorporate them into your custom graph.

To view the data sources in a standard report
•
Display the report and click the Information button in the bottom right corner.
To access the Graph Wizard
•
Select File | New | Custom Graph.
- OR -
Right-click in the treeview and select New Custom Graph.
To create a custom graph
1
Select the type of graph that you want:
•
Bar chart
•
Stacked bar chart
•
Pie chart
•
XY graph
•
XY stacked graph
2
Select the data source for the graph.
3
Select the fields that should be used as data values, category labels, or series labels to generate data for the graph.
After you have selected the data sources and fields, you do not have to click Next. Optionally, you can
•
Select the page you want to use from the list on the left side of the page.
- OR -
•
Click Finish to create the custom report.
4
Optionally, select filter criteria to limit the results that are used to create the graph.
•
To add a filter, click Add New Filter.
•
To remove a filter, select the check box beside the filter and click Remove Filters.
The Date filter is always selected. The default value is “last week”. You can override the Date default value to select a different time period but you cannot remove the date filter.
5
Select the order in which the data should be displayed.
6
Specify the format details, such as the axis titles and whether the data used in the graph is also included as a table. To include a table with the graph, select Show Data.
7
Enter a description for the graph.
8
Click Preview to display the resulting graph.
9
If there are no changes, click Finish.
10
Select File | Save.
11
Enter a name for the report and save it to the My Reports folder.

Guidelines for Creating Bar Graphs

The following guidelines apply when creating bar graphs and stacked bar graphs using the Graph Wizard.

To plot a bar graph, you must, at a minimum, select fields for the following:

•
One data value and one category label
- OR -
•
Two or more data values
General Rules for Bar Graphs

The following are general rules that apply when you create a bar graph:

•
Fields selected as category labels are used to label the bars on the vertical axis.
•
Fields selected as series labels are used to determine the color of the bar and the caption in the graph.
•
Data values determine the size of a particular bar. The fields that you select should reflect statistical values.
•
You can select one data value and one series label, or you can select two or more data values. However, you cannot select multiple data values and a series label.
Examples of Valid Axis Selections for Bar Graphs

In the first three examples, the selected data source is Servers - Server Activity Totals. In the fourth example, the data source is Storage - Exchange Database Summary.

 
Table 6. Examples of valid selections for bar charts.
Axis Selection
Results
 

One data value

One category label

The values of field selected for the category label is used to label each bar in the bar graph.

In this example, the following data source and fields (values) were used:

Datasource:
Servers - Server Activity Totals

Data Values:
External User Messages Received

Category Labels:
Region

Two or more data values

Each field selected provides data for a bar.

In this example, the following data source and fields (values) were used:

Datasource:
Servers - Server Activity Totals

Data Values:
External User Messages Received

External Messages Sent

Two or more data values

One or more category labels

The fields selected as the category labels are used to categorize the values on the vertical axis.

Each category has a bar for each data value. The legend title contains the field display-name.

In this example, the following data source and fields (values) were used:

Datasource:
Servers - Server Activity Totals

Data Values:
External User Messages Received

External Messages Sent

Category Labels:
Region

One data value

One category label

One series label

The value of the category label determines the groups of bars. The value of the series label determines the color of the bar, and the legend label.

The following data source and fields (values) were used:

Datasource:
Storage - Exchange Database Summary

Data Values:
Database Size (MB)

Category Labels:
Region

Series Labels:
Database Type

All the blue bars are mailbox databases, and yellow are public folder databases.

Guidelines for Creating Pie Charts

The following guidelines apply when creating pie charts and multi-pie charts using the Graph Wizard.

To create a pie chart, you must, at a minimum, select fields for the following:

•
One data value and one category label
- OR -
Two or more data values
General Rules for Pie Charts

The following are general rules that apply when you create a pie chart:

•
Data values determine the relative size of wedges in each pie.
•
Fields selected as series labels determine the color of the pie wedge, and what information is displayed in the legend of the pie chart.
•
You can display multiple pies within a pie chart by selecting a Multi-Pie Selection field, or by selecting two or more data values and at least one series label. The values of the Multi-Pie Selection field determine to which pie a particular data value belongs.
Examples of Valid Axis Selections for Pie Charts

In the first three examples of pie charts, the selected data source is Mailboxes - Mailbox Activity Details. In the fourth example, the data source is Storage - Exchange Database Summary.

 
Table 7. Examples of valid selections for pie charts.
Axis Selection
Results
 

Two or more data values

Each field provides data for a pie wedge.

The value of the data labels determine the color of the wedge, and the legend label.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

Data Values:
Messages Sent

Messages Received

One data value

One series label

The value of the series label is used to associate data values with a particular pie wedge. There is one pie wedge for each series value.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

Data Values:
Messages Sent

Series Labels:
Region

Two or more data values

One series label

The value of the series label is used to associate values with a particular pie wedge. There is one pie for each data value.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

Data Values:
Messages Sent

Messages Received

Series Labels:
Region

One data value

One series label

One Multi-Pie Select field

The values of the Multi-Pie Select field determine on which pie to plot the values. The value of the series label determines with which pie wedge the data values are associated.

In this example, the following data source and fields (values) were used:

Datasource:
Storage - Exchange Database Summary

Data Values:
Database Size (MB)

Series Labels:
Region

Multi-Pie Select:
Database Type

Guidelines for Creating XY Graphs

The following guidelines apply when creating XY graphs and XY stacked area graphs using the Graph Wizard.

To generate an XY or stacked area graph, you must, at a minimum, select fields for the following:

•
one X-axis (horizontal) value
•
one Y-axis (vertical) value
General Rules for XY Graphs

The following are general rules that apply when you create a XY graph:

•
The X and Y values determine successive points on a line.
•
In most cases, the X-axis value is a date or time field.
•
The series label values determine with which line the point is associated.
Examples of Valid Axis Selections for XY Graphs

In the XY graph examples, the data source is Mailboxes - Mailbox Activity Details.

 
Table 8. Examples of valid selections for XY graphs.
Axis Selection
Results
 

One X-axis value

One Y-axis value

The X-Y data points plot successive points on a line.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

X-axis Values:
Date

Y-axis Values:
Messages Sent

(The data is filtered for last month.)

One X-axis value

Two or more Y-axis values

Each Y-axis value is plotted on a separate line, against the supplied X-axis value.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

X-axis Values:
Date

Y-axis Values:
Messages Sent

Messages Received

(The data is filtered for last month.)

One X-axis value

One Y-axis value

One series label

The X-Y values are plotted as lines.

The value of the series label determines with which line a point is associated.

The following data source and fields (values) were used:

Datasource:
Mailboxes - Mailbox Activity Details

X-axis Values:
Date

Y-axis Values:
Messages Sent

Series Labels:
Region

(The data is filtered for last month.)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating