Quizz with multiple categorie scores | Community
Skip to main content
Answered

Quizz with multiple categorie scores


  • Explorer
  • 2 replies

Hi guys,

I’m trying to put together a Typeform which has 5 different categories. All categories contain 4 questions with 1-10 opinion scales. 

The purpose is to direct participants towards the category of their business with the lowest score, all with a seperate ending screen:

  1. People (v1)
  2. Strategy (v2)
  3. Execution (v3)
  4. Cash (v4)
  5. Leadership (v5)

Right now I’ve got this working in Paperform for a while, which has category scoring and a bit more calculating capabilities. But Typeform is so much more user-friendly and customisable (and all of my other surveys are Typeform), so I’d love to be able to make this work.

I’ve read a couple of posts about similar problems here and here for example, but I can’t seem to figure it out.

I’m adding up subtotals for each category like this: 
 

 



So I’ve got 5 subtotals ranging from 4 to 40. These are working fine. The problem is comparing the subtotals and getting the right ending. I’ve “cloned” all subtotals in order to do comparisons between the different categories: v1_1 through v1_4 are the same as People subtotal sub_people, v2_1 through v2_4 are the same as Strategy subtotal sub_strategy.

After participants complete the Strategy category I think I need to do a first comparison. This comparison is working:
 


I subtract the People subtotal (v1_1) from the Strategy subtotal (v2_1). In case this is lower than zero there is a point added to a total Strategy score (v2_score), in case this is greater than zero I add a point to a total People score (v1_score). So a point gets added to the lowest rated category.

After the next category I’m running into problems. I don’t know how to do comparisons after participants complete the Execution category since it’s comparing 3 variables.

Do I keep creating new branches? A branch with the Execution questions in case People is the lowest rated category, as well as a branch where Strategy is the lowest rated category? 


That would mean 4 branches coming after the Cash category? Really not sure what’s the way to go.

Thanks in advance for all help!

Tim

Best answer by john.desborough

@tvds - welcome to the community and the nightmare lol from a fellow user

these are a complicated beast to try and walk through from the logic perspective, as you can see/feel.

i have included a screenshot of a 5 variable eval grid that ties into how i would walk through the evaluation (you pointed to a couple of examples in your earlier post that were ‘mine’ so this is a progression from those if you will). My example is based on ‘greater than’ but can be flipped easily in terms of going for lower numbers  - more comments below image

in my image if i was focused on creating highest score wins, i would add one point for each statement being true in the vertical column, giving me a max for each - and a unique win path to an ending page - of 4. In your case, i would add 0 for each true statement, giving you a unique win path to ending statement if v1_gt_total (for example) = 0. if every other value was greater than v1, it is absolutely the lowest score. 

the issue will come when you have ties at the next level - how will you break them?  that part of the decision tree is something that you should have pathed out on a napkin or twenty and figure out how you want to influence the path they take. for example: 

  • so, you have 3 scores that are tied - which one of these is the most painful to address? if you had to choose one, which would it be? and then, potentially, route them to that ending page.. with a reminder note that they had two others to come back to later. 

One comment about trying to do all of this inside the typeform and present options - you ARE limited by the logic available in the platform in order to give an instant response to the user (barring using API and Webhooks that might help). You may want to consider the ‘guide them down one path’ approach in the form BUT ask them for an email address if they want to receive a report based on their inputs that addresses all the combinations/tied-score endings… Connecting the form to Google Sheets would allow you to do much more analysis, even in a templated fashion, to look at the ties and combinations and provide some details from the spreadsheet into a report template, and emailed back to the user (look at the Document Studio addin as a possible tool). That might give you more control over what you are able to provide to the user. 

 

just some thoughts that might help

cheers

View original

6 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5267 replies
  • Answer
  • May 5, 2021

@tvds - welcome to the community and the nightmare lol from a fellow user

these are a complicated beast to try and walk through from the logic perspective, as you can see/feel.

i have included a screenshot of a 5 variable eval grid that ties into how i would walk through the evaluation (you pointed to a couple of examples in your earlier post that were ‘mine’ so this is a progression from those if you will). My example is based on ‘greater than’ but can be flipped easily in terms of going for lower numbers  - more comments below image

in my image if i was focused on creating highest score wins, i would add one point for each statement being true in the vertical column, giving me a max for each - and a unique win path to an ending page - of 4. In your case, i would add 0 for each true statement, giving you a unique win path to ending statement if v1_gt_total (for example) = 0. if every other value was greater than v1, it is absolutely the lowest score. 

the issue will come when you have ties at the next level - how will you break them?  that part of the decision tree is something that you should have pathed out on a napkin or twenty and figure out how you want to influence the path they take. for example: 

  • so, you have 3 scores that are tied - which one of these is the most painful to address? if you had to choose one, which would it be? and then, potentially, route them to that ending page.. with a reminder note that they had two others to come back to later. 

One comment about trying to do all of this inside the typeform and present options - you ARE limited by the logic available in the platform in order to give an instant response to the user (barring using API and Webhooks that might help). You may want to consider the ‘guide them down one path’ approach in the form BUT ask them for an email address if they want to receive a report based on their inputs that addresses all the combinations/tied-score endings… Connecting the form to Google Sheets would allow you to do much more analysis, even in a templated fashion, to look at the ties and combinations and provide some details from the spreadsheet into a report template, and emailed back to the user (look at the Document Studio addin as a possible tool). That might give you more control over what you are able to provide to the user. 

 

just some thoughts that might help

cheers


  • Author
  • Explorer
  • 2 replies
  • May 10, 2021

Thanks John! Really appreciate you taking the time to get back to me. 

What I ended up doing was basically make a giant decision tree for all possible scenario’s. Constantly comparing the lowest rated variable to the variable next in line to check whether that next one is lower or not. 

This is actually working now :)! So now the next step is figure out how I’d like to break tied scores. Then I’ll configure the follow-up through Google Sheets and Zapier. It was an intense puzzle but doable in the end. 


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14884 replies
  • May 11, 2021

Hi @tvds If you don’t mind sharing your workflow/setup here in case anyone else happens to be looking for the same setup, that would be great! :grinning:


  • Author
  • Explorer
  • 2 replies
  • May 12, 2021

Sure, @Liz. I set up the Typeform based on this decision tree (excuse the messy drawing).
 


P refers to the People category, S to Strategy etc. as in my original post. This creates all these different paths. So there’s 2 sets of questions for Execution, one for P < S and one for S < P. Then I ended up with 4 sets of questions for Cash and 6 for Leadership. There were some duplicate comparisons at the end of the tree between Cash and Leadership, that explains the arrows on the right past Leadership.

All questions have a subtotal variable (so sub-people for People questions), plus 4 cloned variables (v1_1 through v1_4 for People) to do comparisons later on in the decision tree without affecting the subtotal variable. Finally all categories have 1 scoring variable - v1_score for People through v5_score for Leadership.
 


So after the last Strategy question there is the first comparison (between People and Strategy) in order to determine to which set of Execution questions it’s going to go. So basically I’m constantly comparing the lowest value of 2 variables to the variable next in line. 
 

So after subtracting People (v1_1) from Strategy (v2_1) there will be going 1 point to the either the People total score (v1_score) or the Strategy total score (v2_score).
 

Then based on which of the 2 is equal to 1 it jumps to separate Execution category sets where either People or Strategy gets compared to Execution. Then repeat this a lot of times 😉.

Hope that clears it up a bit for anyone trying something similar.


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5267 replies
  • May 12, 2021

@tvds - nice job and much neater printing than mine! 

des


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14884 replies
  • May 12, 2021

Oh wow! This is great, @tvds . Love the drawing - much cleaner than mine would ever be ha! Thanks for sharing. 


Reply