6 Replies Latest reply on Feb 1, 2013 5:29 AM by Olga Polyakov

# Bins of uneven sizes

Hi All,

Is there a way to make bins of uneven sizes in Tablea?  This is what I'm shooting for.

Thanks,

Olga

• 0.00 < x ≤ 2.00
• 2.00 < x ≤ 2.50
• 2.50 < x ≤ 3.00
• 3.00 < x ≤ 3.50
• 3.50 < x ≤ 4.00
• 4.00 < x ≤ 4.50
• ###### 1. Re: Bins of uneven sizes

Not via the built in binning, but you could write a calculation to do it

if [measure]>0 and [measure]<=2 then "0 to 2"

elseif [measure]>2 and  [measure]<=2.5 then.......

end

• ###### 2. Re: Bins of uneven sizes

Hi Olga,

Not with the official "bins", but you can do it with a calculated field that will look something like this:

IF [Measure]>0 AND [Measure]<= 2 THEN [DoThis]

ELSEIF  [Measure]>2 AND [Measure]<= 2.5 THEN [DoThis]

....

END

The thing most people miss [because it is "normal" syntax in math] is that in Tableau you have to repeat each element of the equation when stringing them together with AND and/or OR [little bit funny?]

So

0.00 < x ≤ 2.00

has to be expressed as

0.00 < x AND x ≤ 2.00

Knowing these guys are all Stanford math whizzes, I'm guessing they consider your construction a bit of "short-hand", so they don't choose to recognize it. [Just a guess.]

--Shawn

1 of 1 people found this helpful
• ###### 3. Re: Bins of uneven sizes

Alex, in the future we would ALL greatly appreciate it if you would toggle the "I've got this flag" to on, so the rest of us don't waste our time on the same question!

I'm just saying...

--Shawn

EDIT: What? You didn't see the new "I've got this flag" Dustin just added? Sorry, no insult intended.

Message was edited by: Shawn Wallwork

• ###### 4. Re: Bins of uneven sizes

Did exactly the same thing this morning. Needless to say your answer was more detailed - you know what I'm like....

• ###### 5. Re: Bins of uneven sizes

Alex Kerin wrote:

Needless to say your answer was more detailed - you know what I'm like....

I do indeed know, even though we've never meet. [Weird that.]

--Shawn

But just to be clear this was NOT really a msg to Alex; but one for my friend Dustin. Hey dude!

• ###### 6. Re: Bins of uneven sizes

Thanks guys - That helped