I want to display a table that tells me the average, sum, count, etc. for several fields in my data. Is there an easy, general way to do this?
For example, I have 1 row per person, followed by columns for various values like age, height, weight. I want to know summary for those columns to understand how many people have data and what the avg/min/max is.
e.g. 1000 people
995 have a value for age; 40/18/65 avg/min/max
800 have height; 160/140/180 cm avg/min/max
etc...
resulting table has column 1 = field name, column 2= count, 3=avg, 4=min, 5=max
