Orderable List: Aggregating Ranked Responses

Good Morning,

I am trying to figure out how to report the results of a ranked response form. For instance, I want to know the order that was chosen for the 20 or so projects I have listed. When I check the responses, they are listed according to each persons response, but I want to see what the group chose overall. Is there a way to do that? Thanks!

Hi Paul,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

To see the overall group ranking for your projects, you can use Jotform Tables to aggregate and analyze the ranked responses. Here’s how to do it:

1. Open your form's submissions in Jotform Tables.
2. Use the "Group by" feature on the column with the ranked responses. This will group entries by the answers, giving you a structured view of how many times each project was ranked in each position.
3. Alternatively, use the "Summarize with a chart" option on the same column to generate visual summary charts that show the distribution of rankings across all respondents.

This way, you can get an overall picture of the group’s preferences rather than individual responses.

Give it a try and let us know how it goes.

No, how do I get to the "Group by" feature on the column?

Hi Paul,

To use the "Group by" feature in Jotform Tables, open your form's submissions and click the menu at the top of the column with the ranked responses. Then select "Group by" from the dropdown. This will group entries by the answers, helping you see the overall ranking.

NO, There is no feature that says "Group by"

Hi Paul,

The "Group by" feature is available only for Single Choice, Multiple Choice, and Dropdown columns in Jotform Tables. If your ranked response column is a different type, this option won't appear.

To analyze ranked responses overall, you can use the "Summarize with a chart" option from the column menu. This will show you a visual summary of how the group ranked the projects.

When I summarize with a chart, there are many responses with the same rank number. I only have 15 options but there are more than 15 items in the ranked response summary

Hi Paul,

The "Summarize with a chart" option shows all unique responses, which can include multiple items with the same rank number if respondents ranked items equally or left some ranks blank. This can cause more items to appear than your original 15 options.

To get a clearer overall ranking, consider exporting the data and using a spreadsheet to calculate average ranks or totals for each project.

How can I have the data listed from 1-25 in order of preference

Hi Paul,

To list your ranked data from 1 to 25 in order of preference, you may need to export your submissions to a spreadsheet program like Excel or Google Sheets. There, you can calculate average ranks or totals for each project to get a clear ordered list.

Jotform Tables' built-in summary charts may not directly sort all ranked items in one list if there are ties or multiple ranks.

Once it is in an excel format, how do I sort the data? It seems your data comes over unsorted

Hi Paul,

After exporting your data to Excel, you can sort it by selecting the column with the rank numbers, then using the Sort feature in Excel's Data tab. Choose to sort from smallest to largest to list the projects in order of preference from 1 to 25.

If the data appears unsorted, make sure the rank column is formatted as numbers, not text, to ensure proper sorting.

Hi Paul,

Thanks for reaching out to Jotform Support. If I understood you correctly, you're looking for a way to view the list of options that all submitters selected by rank or in order. If so, will a result like the one in the screenshot below work?

If yes, you can achieve this by creating an HTML report for your form. Let me show you how to do that:

1. On your My Forms page, select the form and click on Reports at the top.
2. Click on Add New Report, and select HTML table from the options.
3. Set up the Report Name and Report Configurations as desired.
4. Click on the Create button at the bottom.

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Once we hear back from you, we'll be able to help you with this.

Hello,
This is not what I want. I want a report that compiles all the responses
and ranks all the answers so that I may know what the most popular, to the
least popular choices were for all respondents combined.
Thanks,
...

Hi Paul,

I'll need a bit of time to look into this. I'll get back to you as soon as I have a solution or a workaround.

Thanks for your patience, we appreciate it.

Hi Paul,

I've explored various workarounds using our existing features to summarize the Orderable List widget data according to your requirements, but I'm afraid I couldn't find a suitable solution within the current functionality. As a workaround, I recommend exporting your data to an Excel file. This will allow you to leverage Excel's formulas and features to create the summary you need. You may need to split the data that is in a single column into separate rows to facilitate working with it for your report.

Let us know if you have any other questions.