|
There are different ways to create averages, depending on what you are doing.
Method 1:
Averaging a time series dimension up to a higher periodicity e.g. when a table contains monthly data, you can average the data for those months into quarterly, semi-annual, or annual data
This method applies to either the Browser or the Builder
To do this:
1. Open a table with a periodicity that is less than annual
2. From the View menu, select Time Series
3. Select the frequency of the time interval you want to display and select average aggregation area
4. Click OK
You will now see data that is averaged over time.
Method 2:
Define a computed group
If you want to create an average in a dimension that is not a time series dimension, you can use computed groups to enter any formula.
This method applies to either the Browser or the Builder
To do this:
1. Make sure the table in which you want to create the average is not read only. If the table is read only and this is a temporary calculation, from the View menu, select Worksheet. If this is not a temporary calculation, make the table read/write or Save As a new copy of the table.
2. Select the items that you want to average
3. From the Item menu, select Define Group
4. Enter a new item code for the average
5. In the Group Type area, select Computed
6. Enter the formula for calculating the average. You can use the << button to copy the item's codes into the formula. Example formula: {Ontario+Quebec)/2
7. Click on the OK button
8. From the View menu, select Calculate
Method 3:
Averaging a numeric source field when building a table from an extract.
This method applies to either the Browser or the Builder
To do this:
1. Open your extract
2. Drag your row, column, and other dimensions into the table.
3. Drag your numeric field to the cell area
The Edit Unit Item box appears
4. Type in the name for your average and from the Calculated As box, select Average
5. Click OK
6. From the Data menu, select Go to build your table and see the average
|
Support 
Favoured: 0
