Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Average of a whole row of data

niomimonteiro
6 - Meteoroid

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!

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

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
6 - Meteoroid

Thank you!!

Aaron_Harter
11 - Bolide

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:

10-8.2.PNG10-8.22.PNG

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @niomimonteiro 

 

Cheers and happy analyzing 😀

niomimonteiro
6 - Meteoroid

Thank you, I shall try it out!

TheOC
15 - Aurora

hi @niomimonteiro 

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

 

TheOC_0-1602182561797.png

 

This is very similar to @Aaron_Harter 's method!

 

niomimonteiro
6 - Meteoroid

Thank you so much!

Labels