2 Replies Latest reply on Feb 26, 2012 8:23 PM by Dimitri.B

# range for each bin

hi all,

someone know if it possible to create for each bin a differnt range of value?

for example: i want to show how many student got betwwen 90-100 and how many got between 65-89 and so on.

tableau only let me to choose the range uniform to all of the bins.

thank

gavriel

• ###### 1. Re: range for each bin

Hi Gavriel, the short answer is: no it is not possible to change the range, but this is the second question (request for) about this feature just this weekend. So I'm thinking it might be something someone (maybe you) should put in the Ideas forum so we can all vote on it (you've got my vote)

--Shawn

• ###### 2. Re: range for each bin

You might have some success with a custom-made binning calculation like:

IF 0 <= SUM([Sales]) AND SUM([Sales]) < 5000 THEN '1 - 5 K'

ELSEIF 5000 <= SUM([Sales]) AND SUM([Sales]) < 15000 THEN '5 - 15 K'

ELSEIF 15000 <= SUM([Sales]) AND SUM([Sales]) < 50000 THEN '15 - 50 K'

ELSE 'other'

END

It works, but is not ideal and may cause some issues.