Automate calculations of average of all assessment respones

@Irica - i would suggest using Google Sheets connected to your typeform to capture the output and do your analysis there

• create a reporting tab and pull in the data you want from the main tab using arrayformula() function
• create the necessary ‘calculations’ for calculating the value you want and embed that in the header row using the arrayformula() function to wrap around the calculation
  • this will automatically cascade the value down the column each time a row of data is added
• you can set up a filter on the column(s) that you want to use to filter the data - ie company id or something like that. or set up a tab where you manually enter in the company id in column A and use lookups to go through the data and calculate the data from another tab … 

just a few thoughts 

if you want to calculate averages, you can use logic rules to assign ‘points’ to variables - including subtotals for different categories in your form - and then divide the subtotal variable by X where you put in the value in the logic rule 

there are a few funky things about how typeform calculates values - if you want a percent, you need to divide by whatever value and then multiply by 100 ie 6 divided by 10 x 100 gives you 60%; typeform only goes to two decimal places in calculations, etc. 

des