How to: 
You can view any two metrics, two objectives, or one metric and one objective, to determine their relationship, or correlation. For example, you can:
There are many ways to correlate data using various statistical methods. PMF uses the percent achieved of an objective or measure to determine how points of data are plotted on the Correlation scatter plot. Each plotted dot represents the intersection of a single point in time for two different metrics. The Correlation view displays a linear plot showing the relationship between all points of data.
The following image is an example of the PMF Correlation view.
The Correlation view also displays the correlation coefficient equation, which indicates the correlation of the data. The following are the three possible types of Correlation:


Tip: Selecting the widest possible range of time that is appropriate for your needs utilizes the most data and produces the most accurate correlation results.
If you selected Metric in the Synchronize Y to X axis on field, the YAxis metric will mirror the XAxis metric that you choose here.
If you selected Dimension in the Synchronize Y to X axis on field, the YAxis dimension values will mirror the XAxis dimension values that you choose here.
If you selected Metric in the Synchronize Y to X axis on field, the metric chosen for the XAxis automatically appears here.
If you selected Dimension in the Synchronize Y to X axis on field, the dimension and its value chosen for the XAxis automatically appears here.
Tip: Depending on your browser security, you might be asked if you want to open or save the file. Click Open.
PMF generates two views.


As manager of the Boston sales office, you frequently research causeandeffect relationships to find ways to improve the contribution of your office to the health of the company. The Boston sales office in your organization has shown strong sales. You would like to see how sales have affected profit. To correlate sales and profit in the Boston office:
In the dropdown menu below the Measure and Objective options, select Sales. In the Dimension dropdown menu, select Organization and select Boston in the dropdown menu below that, under Sales, US, and East Coast.
Notice that the value for the Dimension field Organization and the value for Organization Boston automatically appear in the YAxis specification.
An example of the completed form is shown in the following image.
PMF displays a scatter plot, and correlation data in an Excel spreadsheet, as shown in the image below, to compare sales and profit for the Boston office.
The Boston stores in your company historically report a profit that reflects a national trend, while the St. Louis stores historically fall below that trend. You need to examine how St. Louis profit is doing compared to the national trend reflected by Boston profit. To correlate profit in the St. Louis stores with profit in the Boston stores:
Notice that the Profit measure automatically appears in the YAxis specification.
In the dropdown menu below Dimension, select BOS (Boston).
In the dropdown menu below Dimension, select STL (St. Louis).
An example of the completed form is shown in the following image.
PMF displays two views comparing profit in Boston and St. Louis, as shown in the following image.

WebFOCUS 