The sort for tag is used on text variables to sort and reorder list options. It requires a list or sheet name and the weight decorator.
In this example, the sort for tag at QRESTAURANT_ORD uses the number of purchases entered at Q1 for each restaurant to determine the sorting weight. That order is then used for the Q2 option order.
Additional examples
Sorting values from an add-to-100% table
This example uses the percentages entered for each brand at Q3 to set the sort for weight. The QSPEND_ORD variable then determines the order of NPS questions in the block.
Sorting options in reverse order
Using sort for with ranking questions differs because rankings use '1' as the highest value, while sort for treats '1' as the lowest. This means the lowest-ranked item gets the highest weight. To correct this, assign negative weights, as sort for will sort -1 first, then -2, -3, etc.
Comments
0 comments
Please sign in to leave a comment.