This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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: