Alteryx Designer

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

Weighted % of Shipments and Weight On Shipment Lanes

Highlighted
6 - Meteoroid

Hi, 

 

I'm looking to achieve the % weight and % number of shipments per lane. I thought this could be achieved via the use of the weighted average tool, but can't seem to get this to work how I want it. Below is an example of the output that I need and I've attached the data I'm inputting into the workflow; 

City to City LaneCocoon Total Empty WeightGTC Total Empty WeightVIP Total Empty WeightGrand Total WeightCocoon Total Empty Weight_Weighted AverageGTC Total Empty Weight_Weighted AverageVIP Total Empty Weight_Weighted Average
Jenbach-Zurich10246140.6010386.698.6%1.4%0%

 

Many thanks, Stuart

Highlighted
Alteryx
Alteryx

Hi @sevans 

 

I have attached a workflow below which will achieve the output below by just adding in a Formula tool to perform the % calculations.

 

When you refer to the weighted avg, does it need to take anything else into account, or does this achieve what you are after?

 

Thanks

Will

Highlighted
17 - Castor
17 - Castor

Hi @sevans 

 

1. Since your output doesn't include the Origin Country field, how do you want to handle cases where there are multiple entries for each city to city lane, i.e. Hvidovre-Stuttgart?

2. For cases where the values are null, do you want them treated as 0 or missing? 

 

Dan

 

Highlighted
6 - Meteoroid

Thanks Will. I actually realized moments after my post that this had to be achieved by using a formula tool and so now have the desired outcome I was looking for, thanks for responding to my post.

 

Stuart 

Highlighted
6 - Meteoroid

Hi Dan,

 

Thanks for your reply to my post, I have actually achieved what I wanted by using a formula tool. The result I wanted was at city to city level as country can be rolled up out of this. For anything null, yes, this would be considered as 0 movements. 

 

Stuart 

Highlighted
Alteryx
Alteryx

Hi @sevans 

 

No problem at all, glad you got to your answer! 

 

If you are able to mark this as solved in that case so that other people can view solved issues on the Community.

 

Thanks

Will

Labels