Alteryx Designer Desktop Discussions

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

Create Matrix

Andrea92
7 - Meteor

Hi alll

 

How can I create the format of this matrix attached? 

 

In the file input you find if a product is  been actually purchased (Yes/No) and predicted probability of purchasing the product 

 

Appreciate if you help me with a sample please. 

 

Thanks a lot 

 

Andrea 

1 REPLY 1
ScottE
Alteryx
Alteryx

Hi @Andrea92 

 

I would use two Tile Tools to create your desired range buckets for both Predicted YES and Predicted NO and then Crosstab each one to pivot the ranges to headers. That will allow you to join the YESs and NOs back together and rename headers as needed. 

 

Hope the attached example helps.

-Scott

Labels