What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by HHTTodd 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. 

  • Profile Image
    JotForm Support

    Answered by Kevin_G on May 15, 2017 at 02: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. 

     

  • Profile Image

    Answered by HHTTodd on May 15, 2017 at 03: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. 

  • Profile Image
    JotForm Support

    Answered by Mike on May 15, 2017 at 05: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.