Report Builder: average/mean of data automatically compiled and presented

I am trying to generate reports (bar graphs) from responses to a survey. Participants were asked to rate something on a scale of 1-100. I would like the report to generate an "average" response. Is this possible?

@brianwilliamhunter

Thank you for reaching out. 

I have cloned your form and checked in the Report Builder. As of now, it does not seem you can set it to show the average of all replies. Instead, it shows all replies as they were submitted.

If you would like, I can escalate a feature request to see if this feature can be implemented.

Yes, I would love if they could add in a feature where you present the "mean/average" from a set of data. This seems like it could be a really easy fix. Thanks

Hi there,

Happy to help!

You might be able to do this in-form and have the average present in your report from the calculation on the report. Please allow me a little time to see if this is possible.

In the interim, I have opened a feature request ticket with our development team as my colleague mentioned for our development team to potentially implement this feature. We cannot guarantee that it will be implemented; however, if/when our team has an update for you, we will be sure to communicate it to you here.

Thank you in advance for your patience and understanding!

Thanks for your help! I appreciate it.

Hi again,

Thank you for your patience and understanding!

I have already opened up the feature request ticket and have done some investigating to see if using a Form Calculation widget would help to average out the data you're looking for.

Unfortunately, the only average I could create was the average rating from one submission only and not across the entire set of data. In the report, you can see how many responses answered a specific number on a field and, if you use a Form Calculation widget, you could see what the average answer for each submission is or (as in the screenshot below) what the total rating was of all rating widgets:

Using this data, you could manually calculate an average. However, the feature request ticket has been created with our team and if/when we have an update for you in regards to this, we will be sure to communicate it to you here.

Thank you again for your patience and understanding!

Thanks, appreciate the help! Hopefully it can be worked out soon.