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.