categorize questions

@Liz @carogelin 

i would suggest the following types of ‘stuff’ inside Typeform:

• create variables for each of the items ie v_item1, v_item2 etc
• when someone chooses A or H or Z, add the appropriate score associated with that selection to the variable v_item1 
  • assume that question 3 is where the user selects the value for A
    • if q3=A then add A to v_item1
  • repeat for the rest of the questions where the values are added for H and Z and add the points to v_item1
• that will give you the total value assigned to Item 1 inside v_item1
• do that for each item and you will have the 48 items with cores

for the average of ABCD - i am assuming you are interested in how many times, on average A was selected 

• create a variable for adding the number of times A is selected  say v_A_chosen (same for all the possible selections B, C, D etc)
• using logic rules on each question where the user selects
  • if q3 = A then add 1 to v_A_chosen
  • at the end of the quiz/audit you will have the number of times A was chosen in totoal
  • next you need to divide that number by the number of times it could have been chosen - i would do that in a separate stream like this: 
    • if v_A_chosen greater than 0 then add v_A_chose to v_A_average
    • let’s say there are 9 possible questions where the user could have chosen A, then the average would be calculated as 
      • if v_A_chosen greater than 0 then divide v_A_average by 9  (the number of possible questions to select A) 
    • that will give you a decimal number ie 6 / 9 = .66 
    • multiply that by 100 to get the percentage 
      • if v_A_average greater than 0 then multiply v_A_average by 100

do that for all the values. 

if you do that you should have all the averages and values calculated - based on how i interpreted your question .. all in typeform and with the variables submitted into the results

as @Liz said, you could connect the typeform to a Google sheet and do the same set of valuations therein. 

bonne chance

des