I’m using a rank order question with 5 options, ranking from 1 to 5 with radio buttons. When I export the data, I get it by option instead of by ranking. The example at the top of the image is what I’m getting. The lower part of the image is what I want. Is there a way to set up the question to yield this result?Is there a way to export the data to get this format? Less important question. If I want to use the ranking as a transferable ballot (dropping the lowest opinion and redistributing the ranking until 1 option gets 50% +1, is this something that a report or a data analysis selection can produce for me? Thank you very much.

Hi, one other option to consider that would give you the data in the format you're looking for with a similar respondent experience is to use a transposed matrix table. The only downside is that columns/scale points are not mutually exclusive like they are with the radio rank order, though Custom Validation can be added so that the Count of each column must be equal to 1 in order to proceed.To give it a try, create a Matrix table and set the statements to be "1st choice", "2nd choice", and "3rd choice". Then set the scale points to be "Red", "Blue", "Yellow". Next, enable the "Transpose table" setting so that the statements appear as columns to the respondent.Finally, click "Add validation" under response requirements and set it up like the below:

Rank order question - how to export data by ranking (not by things being ranked)?

Rank order question - how to export data by ranking (not by things being ranked)? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded