Can I build a Trend Report?

  • PDInc
    Asked on April 8, 2019 at 9:49 AM

    I want to send a form to 50 users.  Each month I want to resend the same users the form so that they can update their info with current status.  How can their monthly submissions produce reports in the following ways:

    1. Show each field's growth increase from month to month for the entire group.

    2. Show each field's growth increase from month to month for each individual user.

    Can I do this with Jotform Reports?

    See example form.


    Thanks!

  • Richie JotForm Support
    Replied on April 8, 2019 at 11:18 AM

    You may try the visual report. This will allow you to create graphs form the data in your submissions. You may also specify what field you would like to create a graph.

    Here is a guide:https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions

    However, do note that these are the only fields that you can create a visual report.

    Can I build a Trend Report? Image 1 Screenshot 20

    Please give it a try and let us know if this fits your requirements.

  • PDInc
    Replied on April 8, 2019 at 12:19 PM

    Yes, but how can the report continue to show monthly growth increase?  In other words... The form would be re-submitted each month and the report would show the selected fields results from month to month.

    Thanks! 

  • Richie JotForm Support
    Replied on April 8, 2019 at 1:11 PM

    To clarify, the form submissions would be edited? Or will the form user submit another form?

    If the user will edit the submission, we cannot get a proper data as the data would be over written.

    You may try to download your submission per month.

    https://www.jotform.com/help/73-How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF

    Hope this information helps.