Alteryx designer Discussions

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

Excluded group by

Highlighted
7 - Meteor

I have data of sales in multiple cities. I need to see the effects on the mean and stdev of sales if you exclude each city. Attached a sample workflow that filters out each city and then finds the mean and stdev. In the example there are only three cities. In the actual data, the number of cities is large and is not fixed. In the example, there is also a macro that does the same thing to make it dynamic. Is there any way to make it dynamic without building a macro that filters out each city then calculate the mean and stdev? I don't want to use a macro for performance concerns since I have a large number of cities and I don't want the workflow to do cities one by one. I thought if there is a way where you can group by city, and then do the mean and stdev, not for each city, but for all cities except each, if that makes sense.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

You can definitely do this without a macro, but the computational complexity will probably still exist and therefor I don't think the result would be much faster, but here is how you could do it (example attached).

 

Ben

Highlighted
7 - Meteor

@BenMoss  thanks for the solution

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @ahmedalra , if this resolves your issue can you please mark this post as an accepted solution, not only will that help me catch @jdunkerley79 but it will also help priortize this search result should others have a similar issue in the future.

 

Ben

Labels