Summarizing Input Table Data: options would include: count (the number of responses), sum, average, median... Excel-like functions

  • Profile Image
    centerforentrepreneurship
    Asked on May 18, 2017 at 04:34 PM

    Has anyone found a way to quickly and easily summarize Input Table data?

    I have a table that's 35 rows and 4 columns. When viewed in Excel or Google Sheet that's 140 discrete columns!

    Does anyone have a method for aggregating the results in a 35 x 4 table?

  • Profile Image
    Kevin_G
    Answered on May 18, 2017 at 06:17 PM

    Unfortunately, it is not possible to change how the Input Table displays in the Excel report or the Google Sheets integration, currently each option in the Input Table will be displayed as a single column. 

    How would you like to get the information displayed in the Excel report? 

    Would you like to receive it like a single field just like it displays in the submissions page? 

    Please, let us know, we will be glad to open a feature request on our second level. 

     

  • Profile Image
    centerforentrepreneurship
    Answered on May 19, 2017 at 04:14 PM

    Thanks for the quick response, Kevin.

    I'm not sure the how the data is shown in Excel can or should be changed.

    However, a data aggregation option in the built-in "Reports" feature would work. Options would include: count (the number of responses), sum, average, median... Excel-like functions, but only viewable in JotForm reports.

    This would be a nice-to-have, so it's certainly not a requirement. As such, please give it a low priority.

  • Profile Image
    BDAVID
    Answered on May 19, 2017 at 05:23 PM

    I have forwarded this feature request to our back-end team. You will be notified via this thread if this gets implemented in the future.