- centerforentrepreneurshipAsked 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?
- JotForm SupportKevin_GAnswered 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.
- centerforentrepreneurshipAnswered 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.
- JotForm SupportBDAVIDAnswered 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.