Calculating live average of the book score

I expect the answer to my question is hidden somewhere in you help section but just cant find it. I have a simple form https://form.jotform.com/251058211273044 which just compiles members ratings of a book. Is there a way to generate an average of these scores (for a given book) live and display it back on the form or email it to a individual. of course the form could be downloaded as an excel and the calculation done but it would be helpful if Jotform could do it.

Hi slkeenihan,

Thanks for reaching out to Jotform Support. I understand what you want to do.  Let me look into it and get back to you with a solution.

Thanks for your patience, we appreciate it.

Hi slkeenihan,

To get the live calculating average of the books in your form, you can use the scale rating element instead of the dropdown element. Also, you can create a visual report of your form and embed it to your live website. Let me show you how:

1. In Form Builder, click on the +Add Element button at the upper left side of the panel to open the Form Element Menu.
2. Under the Basic tab, select the Scale Rating element and add it to your form.
3. Click on the Gear icon, go to the Options tab, and change the Highest Rating Value to 9.

Once done, you can now create a Visual Report. This report will update with every new submission data, you just need to refresh the browser. Let me show you how:

1. Go to your My Forms page and click on the Dropdown Arrow.
2. Select the My Reports option in the dropdown menu.
3. Click on the Create Report button at the upper left side of the panel.
4. Select the Visual Report option in the Choose your report type window.
5. Click on the Select a Form option.
6. Then, click on the Next button.
7. Select your form in the Select a Form list.
8. And click on the Select Form button.
9. Then, Enter a Report Name in the Input box.
10. Then, select the Extended Report option and click on the Create button.

After that, you can now embed your Visual Report to your live website, you just need to copy the embed code of the report. Let me show you how:

1. Hover your mouse over to the upper right side of the panel and click on the Publish button.
2. Go to the Embed tab and click on the Copy Code.

Make sure that the Access Report is set to Public before you embed it in your live website.

Give it a try and let us know how it goes.

Thank you for the guidance. The ability to create a live display is great but it is not calculating an average of the entries. Another issue is that the submissions for various books will get mixed up into one graph so I really need to put in some conditional logic so that only submissions for a particular book are displayed. Basically creating a report for each book. Is it possible to have do this?

Hi Peter,

I'll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate.