2 Replies Latest reply on Feb 9, 2016 3:54 PM by Josh Craig

# Binning by decile (for beginners!)

I understand that binning by deciles is a not a straightforward thing to do in Tableau. I've read Richard Leeke's post about creating quantiles using table calculations (Table Calculation: Quantile (version 2) ) but as a beginner in Tableau it's WAY over my head.

I'm hoping if I describe my problem someone can translate his post into language I can understand (or otherwise provide me with another relatively simple solution).

I have data with student test scores. All I want to is rank the scores and then divide them into ten groups each representing a decile. The only way I can figure out to do it is to separately calculate the values for each decile then divide them up manually using the approach described here: Creating Variable Sized Bins | Tableau Software .

Something like this:

IF

[score] <= X1 THEN "Decile 1"

ELSEIF

[score] <= X2 THEN "Decile 2"

etc...

where X1 is a hardcoded value for the 10th percentile value of all scores, X2, is a hardcoded value for the 20th percentile value of all scores, etc.

My intention is to create a bar chart with one bar chart for each decile showing the proportion of all males that fall in each decile of test scores.

Is there a better way to do this? Any help greatly appreciated!!