Create a Convert to Numbers recode in modern reports

Use the Convert to Numbers recode to map choice and ratings questions to numeric values.

Open the modern report.

Using the Convert to Numbers recode, you can assign a number to each answer. When you add a convert to numbers recode field to your report, it is added as a Number tile, which enables you to calculate statistics, such as the average, median, and standard deviation for the recoded field. This type of recode can be used to convert the values and calculate statistics for Likert scales (e.g. Very dissatisfied, Dissatisfied, Neutral, Satisfied, Very Satisfied) and CSAT scores.

You can use the recode in your report in the following ways:

• Add the Convert to Numbers recode field to your report as a data tile.
• Perform significance testing and weighting on reports that include the recode.

Convert to Numbers recode fields cannot be selected as variables in weight schemes when applying weighting to the report.

1. On the report toolbar, click Recodes.
   
2. Do one of the following:
   1. To add your first recode, click New Recode in the center of the Editor.
   2. To add additional recodes, click New Recode in the top right of the Editor.
3. In the Choose the Type of Recode page, select Convert to Numbers.
   The following field types are supported by the Convert to Numbers recode:

   Survey Questions	Profile Variables	Response Data
   Single Choice Single Choice Grid Multiple Choice Multiple Choice Grid Rating (Single Choice tiles only)	Single Choice Multiple Choice	Display Type Respondent Locale Response Status Dataset Type

4. In the Set the Recode Rule page, enter the following information about the recode:
   • Recode Name: The display name for the recode in the report.
   • Recode Description: Optional. A description of the recode, such as its purpose.
   • Based On: The field to base the recode on. You can choose from survey questions, response data, and profile variables.

     If you have created profile variable categories, the categories assigned to each profile variable are displayed next to the profile variable in the Based On drop-down list.

     If you want to save the recode as a recode template, it must be based on a profile variable field.

   
5. Adjust the recode numbers assigned to answers, as necessary.
   You can change the numbers for individual answers, or click Reverse Numbers to reverse the sequence for all of the answers. If there is a Did not answer option for the field, it is assigned a value of 0 and remains at the bottom of the list of answers and numbers.
6. If you want to add a tile for the recode to your report, select the Automatically add a new data tile using this recode checkbox.
   The new data tile is automatically added to the bottom of your report when you create the recode.
7. Optional: If the recode is based on a profile variable, select Save as template to create a new recode template.
   You can save recodes based on profile variable fields as recode templates to use as a starting point to create recodes in any new reports for your community. The template is saved with the Recode Name of the recode you are creating.
8. Click Done.

Related information

• Recode example for modern reports
• Edit a recode in modern reports