Formula Ranking Table


This feature is included the Enterprise plan only.


Wondering how can you use formulas to show your respondents how they scored in an assessment? You may have made a personality assessment, work-style assessment, or any other type of assessment and you want to give your respondents immediate feedback to show their strongest area. You can add the Formula Table variable to your final screen and have all the work done for you in an instant! Here's an example of how it could look:


Formula Ranking Table - example



Watch this video or just follow the steps below which show two different ways of scoring that can be used in setting up your formula ranking table.


Depending on the way the scoring of your assessment works, choose which set of steps you need to follow:

  1. Use Custom Scores to set up a Formula Ranking Table - choose this option when some of your questions are assessing one area, and other questions are assessing other areas
  2. Use Question Logic to set up a Formula Ranking Table - choose this option if the same questions are used to assess different areas. The answer option scores need to be assigned to separate categories so question logic needs to be used.


1 Use Custom Scores to set up a Formula Ranking Table

Using custom scoring to build a formula ranking table when each question is assessing a different category. Let's say you have a assessment measuring both IQ and EQ (Cognitive and Emotional Intelligence). We'll make an example of an assessment which has four questions. Q1 and Q2 measure IQ and Q3 and Q4 measure EQ. Now you want to set up a formula ranking table to show how respondents rate for IQ and EQ and which one is higher.


Now let's see how to do this...


Once the assessment has been created, head over to the Extra Options screen and turn on Custom score


Formula ranking table - turn on custom score


Now you'll be able to give each answer a custom score. These scores will be used in the calculations of the formulas.


Formula ranking table - custom score for answers


Go through each of your questions and assign the score that you wish for the different answers.


Now it's time to create the formulas that will calculate the results of your respondent's answers. Find Formulas in the Extra Options tab.


Formula ranking table - formula


In our assessment example of IQ and EQ, we need to create two formulas, one for IQ and one for EQ. As we mentioned, Q1 and Q2 are measuring IQ, so we want to take the custom score for the answers to each of those questions for the IQ formula. The EQ formula will add the custom scores of Q3 and Q4.



In the formulas section, here's the steps to follow to create your own formula with variables:

  1. Click Variables and select the custom scores you want to be counted for each score from the drop-down menu. In our example, we'll create the IQ formula by calculating *|q1_custom_score|*+*|q2_custom_score|*
  2. Create a formula for each score you want to calculate by repeating step 1. In our example, the EQ formula will be *|q3_custom_score|*+*|q4_custom_score|*
  3. Once you've created all the formulas you need, make sure to click apply to save all your changes


Of course you could make your formulas way more complex than this one, for example adding a few answers together and dividing them by a different answer or by the number of answers to obtain an average.


Now let's see how to include these formulas in the final screen where your respondents can view their score. Head right back to the Questions tab and scroll down to find Final screen. It's easy now! Type your text for the final screen and simply add the variable Formula Result Ranking Table which appears right at the bottom of the list of Variables. Adding this variable will make a table appear on the final screen showing the calculated results of all formulas listed with highest score first.


Formula ranking table - add to final screen


It's a good idea to add some text underneath the variable to explain to the respondent how to understand the scores they will see. Just type your text in the Final message box once you've added the variable. Make sure to Save changes and you're done!


An alternative table you could add is the question block ranking table. This is very useful if you have a few question blocks and want to show your respondents in which area they scored the highest. Read this guide for all the info!



2 Use Question Logic to set up a Formula Ranking Table

You're advanced and adventurous so let's dive right in! You've set up a super assessment where each question measures a few different areas, and the answer chosen will add scoring to one area. 


An example will make things clearer. Let's say your assessment measures IQ and EQ (Cognitive and Emotional Intelligence) and for each question, if answer 1 is chosen, that will be 1 point for IQ and if answer 2 is chosen, that will be 1 point for EQ. You want to show your respondents a table at the end with both of their scores. How is that done?


Firstly, create all your questions. View the quick guide to creating your assessment.


Next, create two formulas, one for IQ and one for EQ. The formula should simply be 0. Don't worry, it won't stay 0, we'll be using question logic to define when points should be added to each formula!



Now it's time to set up question logic. Each answer option will add 1 point to a different formula (IQ or EQ), so we need to set up a rule for every possible answer. Here's an example of how to set up the first rule:



Note what has been done here - when answer 1 is chosen for question 1, we have specified that THEN 1 point should be added to the formula for IQ. The next rule would be that if answer 2 is chosen, then 1 point should be added to EQ. Go through all possible answers and choose which formula the answer will add a point to.


Now let's see how to include these formulas in the final screen where your respondents can view their score. Head right back to the Questions tab and scroll down to find Final screen. It's easy now! Type your text for the final screen and simply add the variable Formula Result Ranking Table which appears right at the bottom of the list of Variables. Adding this variable will make a table appear on the final screen showing the calculated results of all formulas listed with highest score first.


Formula ranking table - add to final screen


It's a good idea to add some text underneath the variable to explain to the respondent how to understand the scores they will see. Just type your text in the Final message box once you've added the variable. Make sure to Save changes and you're done!


Here's an example of how the formula result ranking table will be shown to respondents. The highest ranking formula is shown on top.



An alternative table you could add is the question block ranking table. This is very useful if you have a few question blocks and want to show your respondents in which area they scored the highest.