Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
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!

 


Bulien
niomimonteiro
6 - Meteoroid

Thank you so much!

Labels