Average Attendance between two dates

  • vcmimedia
    Asked 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

  • BJoanna
    Replied 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. 

    Average Attendance between two dates Image 1 Screenshot 20

    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.