Average of a whole row of data

[niomimonteiro]

Hi,

I'm trying to find the average of a whole row of data (example: average of the row [net/gross %]) so that I can use that value to find another row of data (example: total bonus * average of net/gross %). Can someone please help me with this step? 

Thank you!

[atcodedog05]

Hi @niomimonteiro 

You use summarize tool get Total as average.

Check this link out on Summarize tool

https://community.alteryx.com/t5/Interactive-Lessons/Summarizing-Data/ta-p/424417

Hope this helps 🙂

[niomimonteiro]

Thank you!!

[Aaron_Harter · Accepted solution]

Hi @niomimonteiro, 

You'll likely want to Transpose the Data, then use the Summarize tool to calculate the Average values from the original 'rows' in your source data:

[atcodedog05]

Happy to help 🙂 @niomimonteiro 

Cheers and happy analyzing 😀

[niomimonteiro]

Thank you, I shall try it out!

[TheOC · Accepted solution]

hi @niomimonteiro 

I have attached a workflow that created an average value for each row in the input 

This is very similar to @Aaron_Harter 's method!

[niomimonteiro]

Thank you so much!