Sign in
x
☰

Recode dialog

Updated at 2020-03-12 15:23:20 UTC
Recode dialog showing the Codes panel on the left with a "(New code)" button, and the Uncoded values panel on the right listing 8 values: 0, 10, 20, 30, 50, 80, 40, and 70.

The "Recode..." dialog is a useful tool for coding text verbatims. However, there are other practical use cases for the "Recode..." tool. 

You can use the tool to:

  1. Recode values to subsets
  2. Recode values to [NA]

Recode values to subsets

The "Recode..." tool is useful to define and analyze new segmentations of the data. For instance, you can clone an element (e.g. Country) and name it "Region." 

Two data panels showing Country and Region breakdowns with descriptive text about Google Translate functionality. The Country panel displays countries like Australia (7.0%), Czech Republic (7.0%), Germany (7.0%) with blue bars, while the Region panel shows APAC (16.0%), EUROPE (40.0%), MIDDLE EAST (29.0%), and SOUTH AMERICA (15.0%).

In the new element, you can recode the country values into regions using the "Recode..." dialog. You can then press to query in the new element to segment the entire survey by region. 

Recode dialog displaying the Codes panel with "(New code)" and "EUROPE 4" containing Germany, Hellas, Czech Republic, and Austria. The Uncoded values panel shows "(uncoded) 16" with a Search field, Clear button, and a list of 16 countries including Australia, Argentinian republic, Kyrgyzstan, Mexico, and others.

Recode values to [NA]

Below we have a question, Q1, where 5% of respondents answered "0". For analysis, you may not want to include zero values in summary statistics like Mean. 

Bar chart for question Q1 asking "Thinking about your Condition X patients, how many of those are currently receiving a GA (gamma antagonist)?" The chart displays percentage bars for ranges from 0 to 71-80, with the largest bar at 67.0% for "1 to 10", and shows Mean=11.2 highlighted in red box with N=100.

From the element context menu select "Recode..." to bring up the recoding dialog:

A context menu displayed over a bar chart showing options including "Select to copy as text", "Copy as image", "Round by...", "Statistics...", "Color...", "Format...", "Recode..." (highlighted in red with shortcut E R), "Filters...", "Chart type...", "More properties...", and "Edit JSON...".

From here you can filter, select and drag responses to existing or new categories. For this example, we only want to code zeros to "[NA]". 

Recode dialog showing the Codes panel with "(New code)" button and an "[NA] 1" code containing the value 0. The Uncoded values panel displays "(uncoded) 7" with a list of seven numeric values: 10, 20, 30, 50, 80, 40, and 70.

Q1 now doesn't appear to have any 0 values, and Mean has increased. You can press the [NA] button to toggle whether missing values are included in the basis or not.

Bar chart for Q1 asking about Condition X patients receiving GA, now displaying "[NA]" as the first category at 5.0%, followed by ranges 1 to 10 (67.0%), 11 to 20 (16.0%), and others. The Mean value is shown as 11.8 in a red box, with N=100.