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

  • Profile Image
    brianwilliamhunter
    Asked on November 24, 2021 at 10:54 AM

    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?

  • Profile Image
    Hanne_L
    Answered on November 24, 2021 at 11:53 AM

    @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.

    1637772526_619e6cee89d1b_

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

  • Profile Image
    Brian Hunter 
    Answered on November 24, 2021 at 12:50 PM

    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

  • Profile Image
    Katherine_W
    Answered on November 24, 2021 at 01:52 PM

    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!

  • Profile Image
    brianwilliamhunter
    Answered on November 24, 2021 at 02:12 PM

    Thanks for your help! I appreciate it.

  • Profile Image
    Katherine_W
    Answered on November 25, 2021 at 01:38 PM

    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:

    1637865468_619fd7fc6a8eb_

    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!

  • Profile Image
    brianwilliamhunter
    Answered on November 25, 2021 at 03:17 PM

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