Derived Variables

To create the tables and charts we need, we usually need to ‘recode’ some of the variables. In OfficeReports this is done by creating derived variables. OfficeReports has standard functionality to merge and group categorical variables, to create periods from date variables and to create intervals and quantiles from numeric variables. Besides that, you can create just the variables you want by using ‘Formulas’.

All derived variables are based on formulas. These formulas can be changed just by editing or by using the 'Formula Editor'. Here you can also read more about how to refer to the variables and categories in expression and about what operators you can use. It is even possible to create conditional expressions.

It is important to realize that derived variables just like original variables contain observations for the cases (respondents). So it is not possible to calculate NPS by trying to detract the category 'Detractors' from category 'Promoters'. Click here to see how you calculate NPS.

Below we describe how to produce the different kind of derived variables:




This short video introduces some of the options: Creating New Variables