Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Calculating Quartiles using in DB

Highlighted
6 - Meteoroid

Hey People,

 

I need to calculate quartile distribution on the sales quantity column. I have seen lot of post which describe how this can be done using summarize tool. problem I have is I am using in db tools which does not give flexibility to calculate percentile. I have recently started Alteryx and any help here would be greatlyappreciated. My dataset looks like below

 

Customer   Quantity

1                   2

2                   1

3                   4

4                   6

 

Thanks

RATISH

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

The In-Db tool set includes Summarize and Formula tools. If you don't want to use only In-Db tools, you can use the Data Stream In/Out tools to bring your data from the In-Db tools to use the other "regular" Alteryx tools. A Tile tool would be handy in this case. In the Tile tool, use the "Equal Records" tile method and set the number of tiles to 4 for quartiles. 

 

Here's a link to the tool mastery series post on the Tile tool:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Tile/ta-p/30235

Highlighted
6 - Meteoroid

Thanks Charlie that helps.

Labels