How can I create a reviewer question that automatically averages responses in Custom Reports?

A common requirement for Proposals is the ability for reviewers to score proposals on a numerical scale which provides a consistent and objective way to evaluate submissions. By averaging scores, event administrators can easily identify valuable proposals at a glance and make data driven decisions during the selection process.

The most effective way to achieve this is by using Range Input questions in the Reviewer's form. This enables reviewers to provide responses on a numerical scale, supporting consistent and quantifiable evaluations.

1. Creating A Range Input Question

Please note, only the Range Input Question can be used to calculate review questions. Other question types are not supported at this time.

1. From the Event Dashboard, navigate to Advanced > Custom Forms
2. Above the Custom Forms table, select Actions > Create

3. Under the Name field, enter the name of the form
4. Under the Category field, select General Survey
5. Under the Description field, enter any additional information you may wish to include for the question
6. Scroll down to the bottom of the form and select Add Question
7. Select the option at the bottom of the field labelled Range Input which will give your form the option to attach files

8. Toggle on the Required checkbox to require users to answer this question before submission
9. Toggle on the Hide Question checkbox if you wish to hide the question
10. Toggle on the Dropdown checkbox to have the range inputs to appear as a dropdown instead of as a slider
11. Under the Name field, enter the name of the question.
12. Under the Description field, enter any additional information you may wish to include for the question
13. Under the Min Range field, select the minimum number that will appear on the scale
14. Under the Max Range field, select the maximum number that will appear on the scale
15. Select Save Changes

2. Testing Range Inputs

Range Input questions will appear as a slider, users simply click and drag the button to their preferred selection.

If the Dropdown checkbox is enabled, the numerical options will instead appear as a dropdown.

3. Downloading Range Input Results

1. From the Event Dashboard, navigate to Data & Reports > Custom Reports
2. Select Proposals Report from the list
3. Under Fields tab and include or exclude variables like Name and Email and ensure the Review Averages field is included.
   1. This will display the average selected response by each reviewer. Please note, this field only works for range input questions, other question types will not apply to this field.
4. Under Call, Include the call for proposal you wish to view averages for
   1. Please note, this is required or the report will not pull results. Multiple calls can be selected for the same report.

5. Above the report's table, select Actions > Generate Report

6. Refresh the page and select Download Previous Report

The compiled response will be available for download as an xlsx file openable by any spreadsheet application such as Microsoft Excel or Google Sheets.

If you would like to only view the responses directly, use the Form Responses report type and ensure the Responses field is included in your report.