Drag & Drop and Ranking Grid: Report on Rank Not Row Headers

Both our Drag & Drop Ranking question and our Ranking Grid will report and export on the row headers for each question. The report data of an aggregated score and a corresponding rank for each row header/option. Some users are more interested in focusing on the rank and how often each row header or option is selected for each rank. This script will transform the data into a hidden Radio Button Grid to accomplish the rank aggregation for each row header/option.

Check it out the example survey and the results in a example report!

OR

Add this survey to your account!

We'll be using the following Alchemer features  and functions in this example:

• Drag & Drop Ranking Question or Ranking Grid Question
• Radio Button Grid Question
• Custom Script Action

Setup

Start by building your Drag & Drop Ranking or Ranking Grid question.

On a later page, build a Radio Button Grid question with the row headers from your Drag & Drop Ranking or Ranking Grid question as column headers and the ranking score – 1 through however many answer column headers you added – as row headers.

On the same page but preceding the Radio Button Grid question, add a Custom Script action and paste the below code.

ranking_qID = 2 --question ID of the drag and drop/ranking grid
recode_qID = 3 --question ID of the radio button grid into which we are recoding, column reporting values should be exactly the same as ranking question row headers, row titles numeric sequential
next_pageID = 2 --ID of the next page to jump to so respondents do not see page with the radio button ngrid

source_options = getquestionoptions(ranking_qID, 'Reporting')
source_answers = getvalue(ranking_qID)

source_by_rankings  = {}

for key,value in pairs (source_answers) do
   source_by_rankings[value] = source_options[key]     
end

target_question = array_flip(gettablequestiontitles(recode_qID))
--row title => qid

for rank,option in pairs (source_by_rankings) do
  
rank = tonumber(rank)
  
setvalue(target_question[rank], option)

end

jumptopage(next_pageID)

Required Customizations

In the script above you will need to customize variables highlighted in yellow in order to make the script work the way you'd like. Not sure how to find these? Check out our How to Find IDs Tutorial to learn how!

ranking_qID - The question ID of your original Drag & Drop Ranking or Ranking Grid question.

recode_qID - question ID of the radio button grid into which we are recoding, column reporting values should be exactly the same as ranking question row headers, row titles numeric sequential

next_pageID - The page ID for the next page to jump to so that respondents do not see the page with the Radio Button Grid. 

Test and Run a Report and an Export

You'll need to manually record several test responses as Custom Script actions are not triggered by the test data generator.

Start by checking out your Individual Responses under Results > Individual Responses. Confirm that the data from your Ranking question and your Radio Button Grid Question corresponds.

Next, run a Standard Report to confirm that your data is in the format you require.

Customized Reporting Format

Finally, if you plan to use the raw data exports. You'll want to confirm that this data is also formatted they way that you need it to be.