In general, it's usually more intuitive when scale values go from lowest = worst to highest = best. Many of our automations within Displayr, including those for Top 2 Boxes, assume this is how variables are coded. If the scale for your category values goes in the wrong direction, you can use an automation to recode those in reverse order. Note this only changes the underlying Values of the categories, and not the order they appear in tables.
This article describes how to go from the original scale of the values of categories in a variable set:
To a scale where the values are reversed for the category labels:
Requirements
- Familiarity with the Structure and Value Attributes of Variable Sets.
- A variable that uses a scale.
Method
- Select the variable(s) that you wish to reverse the scale for from the Data Sources tree.
- From the toolbar, click Anything
> Data > Miscellaneous > Reverse Scales in Variable Set(s).
- OPTIONAL: If the scale includes a "Don't know" option, you will be prompted to include that assigned value when reversing the scales. In my example above, I have excluded it from the reversal, and it retains its original value.
- You can review the reversed scale by selecting the variable, and then, in the object inspector, going to Data > Properties > Values.
Next
How to Recode Variables Using Category Midpoints
How to Recode into Existing or New Variables
How to Create Top Category Variable(s) (Top 2 Box, Top 3 Box, Top K Box)
How to Create Bottom Category Variable(s) (Bottom 2 Box, Bottom 3 Box, Bottom K Box)
Manipulating Data video