Alteryx Designer Desktop Discussions

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

Best Practices

Simon1187
9 - Comet

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
15 - Aurora
15 - Aurora

@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
9 - Comet

@messi007 

Thanks

Labels