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

    Calculate Average into Rankings Table

    Asked by _McV_ on August 06, 2014 at 04:52 PM

    Is it possible to use submission date to create a table, based on one specific parameter.

    I would like to put the average score of one drop-down parameter into a table, so that, over time, I will beable to see the average for all options.

    Hope this makes sense!

    Cheers.

    table create average
  • Profile Image
    JotForm Support

    Answered by jonathan on August 06, 2014 at 06:25 PM

    Hi,

    Yes it is possible to do Average calculations in the form.

    Check this user guide -How-to-perform-calculation-in-the-form

    What you need to add in the form is a DateTime field and Drop-down field with all the options equivalent to a number value.

    So, if you select multiple values in the drop-down, you can calculate average base on the current date later on.

    Please tell us if this is not what you have in mind.

    Thanks.

     

     

     

     

     

     

  • Profile Image

    Answered by _McV_ on August 11, 2014 at 09:19 AM

    Thanks for the response.

     

    I'm ok with the form, but just need some help generating reports.

     

    I want to show a table, averaging the scores for a certain parameter. So, say 100 forms are submitted with parameter 1 = option 1, the table will show the average all of these scores (another parameter). Effectively, I will then be able to see an average score for each option in parameter 1.

  • Profile Image
    JotForm Support

    Answered by Kiran on August 11, 2014 at 11:48 AM

    I understand that you want to generate custom reports to display average scores of each parameter as a table. Is this correct? Please correct me if you are looking for some other report. I am working on this issue and shall update you with relevant information through this thread shortly.

    Thank you for your patience.

  • Profile Image

    Answered by _McV_ on August 11, 2014 at 12:09 PM

    Ye, that's it. I don't know if that's possible in JotForm?

  • Profile Image
    JotForm Support

    Answered by david on August 11, 2014 at 01:14 PM

    Hi,

    You would need to have the calculations done previous to generating the report.  You can do this by following the guide my colleague referenced.  Then, depending on what kind of report you need, there are several different methods you can choose.  The first is a visual report:

    http://www.jotform.com/help/187-How-to-create-a-Visual-Report-with-your-Form-Submissions

    The second is an excel based report:

    http://www.jotform.com/help/101-How-to-create-an-Excel-Report

    And also a CSV report:

    http://www.jotform.com/help/103-How-to-create-a-CSV-Report

    Please let us know if you have any further questions and we will be happy to help.

    Thank you for using JotForm!