A major shortcoming of this system is that it cannot analyse the differ

A major shortcoming of this system is that it cannot analyse the different fields:
Example:
- Male, female, other
- Amount spent on holiday
- Month when you went on holiday
It would not seem difficult but very useful to group the data and calculate the total amount spent on holiday by gender and period and the average for each person....

Hello,

You have the ability to set filters on your report to only show the submissions that apply to the filter you've set. So if you select a question where an answer equals male it will show all the ones where male was selected from your example.

https://www.jotform.com/help/281-how-to-use-visual-report-filters/

If it's additional calculations you want to do after this data is filtered, then we'd need to make a feature request to the developers. If we need to make a feature request please provide as much detail as to what you would like. We won't be able to guarantee that it gets added or an ETA on when it would be implemented if they move forward with it, but it will help them understand what people are looking for.