Averaging Entire Columns

[Faronnj]

I realize this might be a simple answer but it seems difficult to find on the alteryx community.  I have the following data,

Preop Ref Sph	Postop 1-3mo Sph	> 4-12mo Sph	> 1-2yrs Sph	> 2-3yrs Sph	> 3-5yrs Sph
-9.50	0.00
-15.50	0.75		0.50
-15.50	0.50		0.25
-14.00	0.00	0.00		0
-15.00	0.00	0.00		0
-10.00	-0.50		0.00
-7.75	0	0	0
-7	-1	-1	-0.5
-15	1		1	1
-12.75	0		0	0
-18.75	1.25	1.25		-1.5

I want to do the average, standard deviation, count, max/min to each one of these columns but cant seem to figure it out, no matter the amount I try.  Hoping someone can help me with this simple task.  

Thanks,

Nick 

[NickSm · Accepted solution]

Hi @Faronnj 

You could go through a couple steps of pivoting and using the summarize tool, or..

The Field Summary tool in the "Data Investigation" tab does just about all this for you.

Can always use the traditional Summarize if there's some more dimensions you need that aren't in that given summary.

[Faronnj]

This is exactly what I was looking for! Just have to fix up the table somewhat.  So with the field summary tool, I select the fields I want and it gives me the table I am looking for when clicking the output arrow on the field summary tool but when I connect to browse or output - it still includes all fields.  Is there some way to output just the fields selected? or is the best way to do this with the summarize tool?

[NickSm · Accepted solution]

Depending on how you want the end result table to look, would you just be able to add a Select tool after that Output from the summary and deselect the fields you don't need?

Otherwise you could probably play around with the transpose/crosstab to pivot the table back into a column structure similar to what you had when you started.

[Faronnj]

yea, I just wasnt thinking straight about using that after.  that would definitely work.  

Thanks 

Nick