This article is part of The Definitive Guide to Importing and Preparing Data.
There are two options for creating a top box or other summary variable:
- Insert a subtotal on a variable, which will appear as an additional category in bold on the variable in the web app.
- Create a top box summary variable, that is a separate multiple response variable.
In the below image, the variable on the left is a categorical array with a subtotal added to the variable, which is the "Top 2 Box" column in bold on the right. The variable on the right is a "Top 2 Box" summary multiple response variable that is derived from the array variable. The summary variable is built by only selecting certain values in the array, in this case, the "Top 2" are the "Love" and "Like" columns, though you can configure it to be whichever values you'd like (e.g., "Bottom 2" combining "Hate" and "Dislike").
In the web app
For articles on specific applications of this feature, see the following:
Crunch Automation
Using R
- See the Subtotals and Headings vignette for more information.
- deriveArray() - Specifically the Multiple Response examples.