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%
@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
Hi,
I have checked the various options - percentile, tile and basic data profile but I am not sure any of these solutions give the correct quartile result.
For example, the sequence of 1, 2, 3, 4, 5, 6 should provide a result of :
Lower quartile = (1+2)/2 = 1.5
Median = (3+4)/2 = 3.5
Upper quartile = (5+6)/2 = 5.5
None of the options (percentile, tile and basic data profile) provide that outcome. For example, the basic profile provides the following values :-
25th Percentile = 2.25
50th Percentile = 3.5
75th Percentile = 4.75
Can someone please review and let me know if I am right/wrong ... if right, is there is another way to determine the quartiles?
@CHerv - did you ever figure out this problem?
I had posted the same issue... missed this discussion. Is there a fix for the math yet?
Re: Median and 3rd Percentile Calculation Error - Alteryx Community
