I need help creating a form that counts answer values

In my form "Communication Styles Assessment" I cannot figure out how to make the form count responses correctly. I have 5 initial questions that have assigned point values depending on the answer. I need an output that returns the most commonly selected answer. So if the answers are mostly 1's, or mostly 4's, I need that calculation to determine which result to deliver to the end user.

Hi Emily,

Thanks for reaching out to Jotform Support. To clarify, do you want to display most common answer from all submissions or just for one submission on the form? Can you explain a bit more about the issue, so I can get a better idea of what's happening?

Once we hear back from you, we'll be able to move forward with a solution.

I need to calculate the most common answer for the 5 questions answered on the form. For example, a user takes the quiz and selects the following answers:

1. which word best describes you: Thorough (point value of 2)
2. which word best describes you: Enthusiastic (point value of 4)
3. which word best describes you: Pragmatic (point value of 2)
4. which word best describes you: Detailed (point value of 2)
5. which word best describes you: Fun-loving (point value of 4)

In this case, the most common answer is 2. That number would then trigger what happens next. So based on what their most common answer number is, it would trigger a condition to show/hide specific cards.

Does that help?

Hello Emily,

I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience.

Hello Emily,

I have looked into your form and if I understood it correctly, you want the results to be based on the majority of the selection. Please kindly note that conditions can be set based on a specific value since you are using calculation values. The best approach to this is to have a range for your specified values, like :

1 to 3 points = You are a Driver!

4 to 7 points = You are Amiable!

8 to 10 points = You are Analytical!

Once you are able to get the possible range for the answers, then you can now set up the hide/show condition depends on the results.

Give it a try and reach out again if you have any other questions.

thank you but unfortunately that won't work. they may pick any number of combinations that could result in similar point values. the only way to do it is to create a quiz where it counts the most common answer. I was attempting to do it using the MAX function but I would need the function to analyze an input (ie another field) rather than telling it the specific range of numbers. does that make sense?

Hello Emily,

I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Hello Emily,

The MAX function works when you are getting the highest indicated value, not the Majority of similar numbers collected from the field values. After analyzing this further, it is possible to achieve your requirement, but this will require multiple duplicated fields and multiple calculate and hide/show conditions. I created a sample form here to simplify the process, here is a screencast of my results:

To achieve this, you need to collect the data of your selection individually using another element. In my sample form, I used 'Number Field', just make sure that the calculation values set are all 1 so it will only calculate a 1 entry for that answer:

Once you have added the individual elements for each selection (Number Field), you need to add a condition to copy the values on those fields:

You need to create multiple individual fields for every selection for the single choice field. Now, to summarize which fields are collected, I added a Calculation Widget to calculate how many similar answers are collected on from the single choice elements:

As you can see, added multiple calculation widgets to be able to identify which answers were selected. After that, you can now add your Paragraph Elements for the results and add show condition:

(The following conditions only apply when The Majority of the answers is A, you may need to customize it depends on the structure of your form)

This structure should meet your requirements, but it can be a bit complicated due to multiple duplicated fields. You may apply the same process in your form. Feel free to inspect my sample form on this link.

Give it a try and reach out again if you have any other questions.

Thank you so much! I believe that this format may work! I'll recreate the form for myself tomorrow and follow up if I have any questions. Thank you!

Hi Emily,

I moved your question to a new thread and helped you with that here.