Scroll

Showing a weighted and unweighted base

Showing a weighted and unweighted base

Follow
Summary This article provides a description of how to show a weighted and unweighted base on tables produced in askiaanalyse. It assumes you know how to apply weighting to a table definition. It also assumes you know how to find and amend general settings, change the properties of a calculation and create a new calculation.
Applies to askiaanalyse
Written for Data processor
Keywords weighting; weighted base; unweighted base; totals; analyse; askiaanalyse


Introduction

When weighting is applied to a set of results the total is shown, by default, weighted. You may want to display both the weighted and unweighted base. This article explains the steps you need to take to achieve this.

Set-up required

Step 1 - Remove the default Total row

From the General section of your table definition, select Settings.... On the "Total and caption" tab, de-select the checkbox on Total Row as seen here...



Step 2 - Create a new calculation for the weighted base

From the General section of the table definition, in the pane that displays the calculations, right-click and select Insert. Create a new calculation with the properties shown here:



Step 3 - Create a new calculation for the unweighted base

From the General section of the table definition, in the pane that displays the calculations, right-click and select Insert. Create a new calculation with the properties shown here:



(Optional) Step 4 - Create a new calculation for the base shown when weighting is not applied

You may also want to define a third calculation type for when weighting has not been applied to your tables. To do this, go to the General section of the table definition. In the pane that displays the calculations, right-click and select Insert. Create a new calculation with the properties shown here:



Step 5 - Calculation types to show

Ensure that you have selected the calculation types you wish to show and that they are in the order you wish to show them, as in this example...



(If you need to change the order of a calculation, click on it and drag it up or down the list or use the keyboard shortcut ALT + UP or ALT + DOWN arrow).

Example output

If you have followed all of the above steps (including optional Step 4) then your weighted tables should look something like this:



Any unweighted tables should look something like this:



Have more questions? Submit a request

Comments