community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Calculating Quartiles

Asteroid

Hi Team,

 

Like we have automatic options to do Sum, Count, Avg, Median etc. how dow we get Quartiles in Alteryx?

 

Regards,

Rushabh

Use the percentile option in the summarise and set to 25/75% 

 

2016-07-27_14-13-27.jpg

Alteryx Certified Partner
Alteryx Certified Partner

@jdunkerley79,

 

You're FAST!!!!

 

I was going to go another route and use the TILE tool.  I'd use the EQUAL RECORDS method

and set it up with 4 tiles.  Based on the "Score" or value that we were tiling, I'd not let it break on that field (e.g. all 70.5's should get the same tile).  You can also group by within the tool and get tiles by Gender or other fields.

 

You say summarize and I say tile.  We're both right :)

 

Screen Shot 2016-07-27 at 9.14.43 AM.png

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Sr. Community Content Manager
Sr. Community Content Manager

Couple more options:

  1. Quartiles appear in the Browse tool data profiling information...

browse.PNG

2. And if you need the values in your data stream, use the Basic Data Profile tool...

profile.PNG

 

 

Labels