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.
Calculate Average into Rankings TableAsked 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!
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 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.
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.
Ye, that's it. I don't know if that's possible in JotForm?
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:
The second is an excel based report:
And also 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!