Once the user has created their calculated variable, the next step is to specify the logic based on which they wish to group/transform the available data in their calculated variables. This can be done buy creating buckets and mentioning the data transformation logic in them.
To specify your data transformation logic, in the Data Transformation page, click on Create Bucket.
A pop-up will appear. Enter Bucket Name and click on Create.
The Bucket will get created and will be visible in the left pane of the page under DTS. On the right you will be able to see the features and contents of the bucket which you will use to create your data transformation script.
- To link/group your data and specify source variable, click on Source Variable. Source variables are the ones on which the data is collected, for example: numeric age data collected by the respondents.
- A pop-up will appear with all the variables/questions you have in your survey. Select your source variable. For Example: your Numeric Age Question.
- Click to add Target Variable. Target variables are the Calculated variables in which the collected data has to be transformed, for example: age groups can be created out of the collected numeric age data.
- A pop-up will appear listing all your created Calculated variables(Refer Section Creating Calculated variables). Select the required calculated variable as your target variable. For example: Age group which has all the age intervals.
- The Source Value and Target Value fields/options will modify themselves according to the selected Source and Calculated variables. Considering the Example of transforming numeric age data into age groups, Select the numeric range under the Source Value field. This Range defines the range of the age answered by respondents in your numeric age variable.
- Now for the selected range in Source value field, select a corresponding option in the Target value field by clicking on the Value drop-down. Target value field is basically your calculated variable. The drop-down will give you all the options for your created calculated variable.
- Select the required option to which you want to set range selected in Source value and Click on Set.
- The range selected in Source value will get set in the selected option in Target Value and will be visible in the right pane.
- Continue the same process to set all the data ranges in your calculated variable options.
- If you wish to transform/group a particular value of your collected data into the created calculated variable, select the Value option and enter that particular value under Source Value box. Now you can select a particular option from the Target value box to map your value with.
For Example: If Source Value is 60, then group such respondents into Target value option "Respondents age 60".
- You can map system missing values of your source variable with target value options.
- All other values field if selected captures the un-mapped value from your source variable and you can map these values to any of the options present in the Target value box.
In this way users can create multiple mapping iterations between the source variable and the Target/Calculated variable.
Once you have specified your Data Transformation Logic, the next step is applying or Executing the logic to your data. To know how to Execute your Logic Refer Section Executing Your data Transformation Logic. Once the logic has been executed/automated, you can verify the results by going into Analyze Page.
Transforming Data on a particular Logic applied
Users can apply data transformation logic on a selected filter cut. The filter can be applied by selecting the box which says "Only for the cases where the following logic applies" and clicking on the Define Logic button.
A pop-up will appear where-in you can specify your logic or condition. (Refer section Logic Builder)
The data transformation logic will now work only on the data filtered out on the applied logic.