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

    Average Attendance between two dates

    Asked by vcmimedia on December 15, 2015 at 02: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

    two dates between two dates create a form JotForm date field create
  • Profile Image
    JotForm Support

    Answered by BJoanna on December 15, 2015 at 03: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:

    https://support.office.com/en-us/article/Use-Excel-as-your-calculator-a1abc057-ed11-443a-a635-68216555ad0a 

    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.