In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Calculating a percent across multiple fields in a crosstab

KevinK20
5 - Atom

Hello All,

 

I am looking for help with a solution to calculate a percent and use it to categorize my data into three categories. I am struggling with it because the data is coming in as a crosstab (see attached sample). I need to take the product list and add a field indicating whether the product is out of stock, limited stock or in stock based on availability by plant.

 

What I need to do is calculate (count of stock = "Y") / (count of stock = "Y" + count of stock = "N") in order to assign the item a "stock  status". How can this best be accomplished? The data set I am actually working with is quite a bit larger than what's attached here.

 

Any help would be appreciated. Thanks in advance.

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @KevinK20 I mocked up a workflow let me know what you think?

KevinK20
5 - Atom

Thank you!

Labels
Top Solution Authors