Adding a standard projection to a project scales the weighted data up to a set population number. The number remains the same whether you are viewing a single time period or the total across all time periods. Learn more about Population Projection.
With Projection Weight, you can scale up the data and have the totals summed, for example, when you are counting drinks across a Quarter. Instead of projecting to one total, the totals for each of the three months are added together to create total drinks. Only a Project Owner can create a projection weight.
This feature uses a personalization key so please contact support@infotools.com if you need this activated.
In this article
1. Create a new projection weight item
Like a standard projection, you create a new projection weight by choosing a location in the project tree and clicking on new projection weight from the design menu.
Enter a name for the projection weight and the projection editor will automatically open.
If at any stage you need to manually open the projection editor, highlight the projection item and click library/editor.
2. Projection Editor
a) Add Dimensions
When adding a new projection weight, two dimensions are required. Once the projection editor opens, you can drag one standard, single response axis into each of the dimensions: Dimension 1 and Dimension 2. Do not use an axis with Nets or multiple response answers.
You must add an axis in Dimension 1 and Dimension 2.
When you first add the new projection weight item, Harmoni automatically populates Dimension 2 with the first time period in the project tree marked with a date flag. If you require a different time axis, you must remove and replace it.
Unlike Population Projection, Projection Weight does not require a time period axis, so you can remove and replace the time period with an alternative axis. If there are no time periods in the project, Dimension 2 is left blank and you must manually add the second dimension.
In this example we will use Country for Dimension 1 and Month for Dimension 2.
Click the Edit button for the dimension you need and drag and drop the axis into the drop box.
Only include single response axes in the projection weight dimension fields.
b) Enter Dimension Values
Once you have added the two dimensions you require, you need to add the values to project to in each of the dimensions. Note that you cannot enter the total values; only the intersections for the two dimensions. In the example, the intersection for Country and Month is entered but not the total value for Country. The Country total and Projection total are automatically calculated.
Press save once you have added the required values.
Use the Auto Fill Dim2 option to automatically add the values for you. Enter the first intersecting value and once you click in the second field, or press Enter, Harmoni auto-populates all elements within the dimension.
c) Analysis Table
In the analysis table, you see the projected total for each column, but instead of projecting to the same overall total, Harmoni adds the columns creating a summed total.
In this example, the first table shows a standard Population Projection where Harmoni projects to the same projected total, while the second table has the Projected Weight applied and Harmoni sums the totals.
Although you can only include one time period in a dimension, Harmoni will apply the projection weighting to a constructed, group time period. In this example, month is included in Dimension 2 and the rolled time period, 3MMT, created from month, also has the projection weight applied.
d) Cancel and Clear
The cancel and clear options are at the bottom of the projection editor pane.
- Cancel doesn't save any of your actions. It shows the previously saved state.
- Clear cleans all of the fields. You can use this option if you want to replace all the population figures you have entered so far. Clear will not automatically save; if you close the editor before saving, the values show as they were.
Where to from here?
Learn more about Harmoni.