-
vcmimediaAsked on December 15, 2015 at 2:32 PM
Good Afternoon,
I have created a form that our folks will use to input attendance of our church. I have created a field at the bottom that's called "Today's total attendance" for the particular date field called "date of service".
Is there anyway to create a form or report where i can place a range of dates that will result in the average attendance between the two dates?
Thanks,
My form is: https://form.jotform.com/53484066644158?Kim
-
BJoannaReplied on December 15, 2015 at 3:26 PM
Thank you for contacting us.
If I understood you correctly you want to calculate average attendance from "Today's total attendance" field, between the two dates. You can achieve that by exporting your data to Excel and than in Excel you can calculate average attendance. I have created excel report from your submission. To calculate average attendance in Excel select your data, then click on AutoSum dropdown option and select Average.
This article can help you to perform calculation inside of Excel:
Inside of this guide you can find out how to create Excel report: http://www.jotform.com/help/101-How-to-create-an-Excel-Report
You can also partially download form submissions as Excel, if you want submissions only for specific date of between two dates.
http://www.jotform.com/help/73-How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF
Hope this will help. Let us know if you need further assistance.