Visual Report: How do I calculate the average of all responses?

  • HHTTodd
    Asked on May 15, 2017 at 12:59 PM

    I am asking for 3 separate ratings in a form. Can jotform calculate the average rating for each one and display this in a report?

     

    I understand the data can be exported and calculated in excel, etc, but I need the average data to be displayed live, showing a running average as more responses are submitted. 

  • Kevin Support Team Lead
    Replied on May 15, 2017 at 2:13 PM

    Unfortunately, it is not possible to calculate a total based on information that has been already submitted, although you can create reports, you cannot perform calculations in them. 

    You could achieve this through our API, getting the question and its submitted values, take a look on the following link to get more info about our API: http://api.jotform.com/docs/ 

    We could also open a feature request on our second level, but we cannot ensure this will be implemented, if you would like to open the request, please let us know. 

     

  • HHTTodd
    Replied on May 15, 2017 at 3:52 PM

    Please do. This should be something VERY simple to do on your end. Your competitors offer this. In my opinion, your general interface and widget/app integrations give you a leg up, however the simple inability to perform basic calculations will likely cost you my subscription dollars. I know I'm not alone either, looking through the past years of forum entries. 

  • Mike
    Replied on May 15, 2017 at 5:39 PM

    Thank you for your input. We have visual reports with charts, but they do not show the average.

    I have attached a feature request ticket to this thread and escalated it to our developers.

    There is no ETA, but we will let you know if we have any updates.