Consolidated the Avg Number

[Learner09]

Hello All, 

I am trying to consolidate multiple lines into one the Avg number. Please see the attached example sheet for detail and assist me.  

Thanks,

[davidskaife]

Hi @Learner09 

The Summarise tool will do that for you:

[mceleavey]

Hi @Learner09 ,

All you're looking for here is the Sum tool. This allows you to apply sum, count, average etc. to any grouped or un-grouped dataset.

In your example, you're just looking to provide the average number for a single column of data, you can achieve this by using the Average function in the Sum tool:

This is very basic functionality, so if you're new to Alteryx I suggest looking at the Academy section of the Alteryx Community, and perhaps starting with the Onboarding program, which you can find here:

https://community.alteryx.com/t5/Onboarding-Resources/Designer-Onboarding-1-Get-to-Know-Alteryx/ta-p...

Hope this helps.

M.