We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Designer Discussions

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

Best Practices

Simon1187
8 - Asteroid

Hi there, 

 

I am trying to get the average price for products in sub. Could you please help me with it? 

 

Simon1187_0-1631368104712.png

Thanks, 

 

4 REPLIES 4
Ar13f
10 - Fireball

Dear @Simon1187 

 

like this your mean?

Tyro_abc
11 - Bolide

Hi @Simon1187

 

it needs a simple change, 

Tyro_abc_0-1631378132531.png

Regards

Tyro

messi007
14 - Magnetar

@Simon1187,

 

Below how you can do it 

1- Group by sub and AVG price

2- Join to bring the AVG to each line of product 

messi007_0-1631386523906.png

 

Attached the workflow.

Regards

 

Simon1187
8 - Asteroid

@messi007 

Thanks

Labels