Webi will combine like values unless specifically told not to. For example: You want to find the average numeric answer for a TouchPoint question. The participant's answers are: 5, 5, 5, 5, 1

The actual average is 4, but if you put these answers into a table with the [Response ID] field and asked for an average, Webi would return 2.5. Webi does this because it sees all of the "5" answers as a single answer. Without the proper context, it is averaging 5 and 1. To fix this, context needs to be applied to the average formula as in the formula below.

  • Average([TP Answer] in ([Response ID))

This context specifically tells Webi to average the results of all answers with a different [Response ID] individually, even if some of the results are the same.

For more information on aggregate formulas see: ETO Results: Incorrect Totals/Aggregates.

For more information on averages, visit our Help Manual article here.

Please contact customer support if you need more information or additional assistance.

Did this answer your question?