We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

Assigning Quartiles in Alteryx

ksmith4567
6 - Meteoroid

Hi there,

 

I am trying to figure out how to assign quartiles based on different key metrics and including criteria. In the example below, I want to be able to assign quartiles for the different products but only include products in that same department in the calculation. For example, what quartile do Apples fall into within produce for sales and then for profit. Output would be three new columns that list each product's quartile (1, 2, 3, or 4) for each metric, as shown in the blank columns. Can anyone please assist? 

 

DepartmentProductSalesProfitMarketing CostSales QuartileProfit QuartileMarketing Cost Quartile
ProduceApple1052   
ProducePear1472.8   
ProducePeach1052   
ProduceBanana136.52.6   
Dairy Milk1052   
Dairy Yogurt94.51.8   
Dairy Ice Cream73.51.4   
Dairy Cheese73.51.4   
Dairy Cream631.2   
1 REPLY 1
atcodedog05
21 - Polaris

Hi @ksmith4567 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1642053492123.png

 

Hope this helps : )

 

Labels