Submissions: How to get average for Input Table and Ratings?

Und dann habe ich noch eine zweite Frage: Gibt es die Möglichkeit, dass wir in einem Report einen Mittelwert der Antworten herausbekommen (z.B. bei Eingabetabellen)? Bei den der Sternenbewertung ist es möglich, aber geht das auch bei anderen Eingabemöglichkeiten?

Hi fachgesellschaften,

Thanks for reaching out to Jotform Support. Unfortunately, our German Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in German, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. You want to get the average of responses for the Input Table and Rating in your report? Yes, you can do that. Here’s how to do it:

First, for the Input Table, you set a value for each input:

1. Click the Gear icon from the Input Table.
2. Go to Options tab.
3. Set the Calculation Values (Separate each column with a comma, and row with a new line).

Next, add a Form Calculation field to store the sum of the Input Table values. Follow instructions and screencast below:

1. In Form Elements > Widgets, select and drag the Form Calculation to your form.
2. Click the Wand icon to open the Settings.
3. Click the Add Field button and select the Input Table, check the rows you want to include.
4. Add the Plus (+) icon after each row name so that the values will be added.

Result:

Then, add the Rating element as you normally would:

In the Submissions Table, you can then get the average for the Input Table and Ratings. Follow instructions and screencast below:

1. Add a column to get the Integer value of the Form Calculation. Click Add.
2. Select Formula, then Advanced Formula and add a column name.
3. Select Int then select the Form Calculation column, click Create Column.

Using the column, you can now get the average for the Input Table.

1. Right-click the column header.
2. Hover over to Add Summary.
3. Then, click Avg.
4. The Average will then display in the bottom.

Do the same for the Rating columns. We also have a guide about Jotform Tables that you can check out.

Here is the demo form I used in the example, which you can check and clone.

Give it a try and let us know if you need any other help.

Hi,

Thanks for your answer. I'm not sure if we are talking about the same thing. I will try again to explain what my question is:

Form URL: https://form.jotform.com/232772002524346

We would like to have this weighted average value in the report for the questions 2, 3 (see picture below)? Is it possible?

At the moment we have this values:

• %
• how many have voted for something
• Total votes

It would also be interesting to have total vote per questions. Can we add this also?

Thanks for your answer.

Carole

Hi fachgesellschaften,

Thanks for getting back to us. Allow me to look into this and I will get back to you with an update as soon as possible.

Thank you for your patience.

Hi Shane,

Thank you so much. Do you think it will be until tomorrow?

Carole

Hi fachgesellschaften,

Thanks for your patience, we appreciate it. Upon inspecting the reports, unfortunately, there is no direct way of coming up with the report that you sent. As a workaround, you can download the submissions as an Excel file, then generate your report using excel. You can check this guide as a reference.

Give it a try and let us know if you need any other help.