sgapiResultsQuestionAverage(%%questionID,%%query = "")

Important Update to Custom Scripting

SurveyGizmo's CustomScript Action now supports the LUA programming language. Visit our NEW Lua Scripting Resources!

Legacy Custom Scripting Language Deprecation Plans 

  1. New accounts (created after October 29, 2018) will only have the option to use Lua in scripts.
  2. As of October 29, 2018 Custom Scripting Actions will default to Lua as the scripting type in the Custom Scripting Action for accounts created before this date. You will be able to switch to the Legacy Custom Scripting; though we highly encourage using Lua.
  3. In the long term, Legacy Custom Scripting Actions will be switched to read-only. The exact date on this is to be determined; we will send notifications well ahead of time.

This function returns the average answer of the answers given question ID across all completed surveys in real time.

%%query allows you to optionally specify a query string variable to filter by. Like this: "urlvar_department=support" will return the average value for this question for respondents with the department "support".


This example simply gets the average value for the first question of the survey and displays it.

Check it out in an Example Survey

%%output .= "The average for question 1 is ";
%%output .= sgapiResultsQuestionAverage(2); + ".";

Output would be: The average for question 1 is 2.50.