Averaging Entire Columns

Question

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 SphPostop 1-3mo Sph> 4-12mo Sph> 1-2yrs Sph> 2-3yrs Sph> 3-5yrs Sph-9.500.00    -15.500.75 0.50  -15.500.50 0.25  -14.000.000.00 0 -15.000.000.00 0 -10.00-0.50 0.00  -7.75000  -7-1-1-0.5  -151 11 -12.750 00 -18.751.251.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 Answer

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.

NickSm · Accepted Answer

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.