7 Replies Latest reply on Apr 6, 2017 7:30 AM by Glenn Kuly

# What is the concept of Bins?

Hi Team,

Can any one provide me brief details on what is the Bin is all about in Tableau with a good example?

• ###### 1. Re: What is the concept of Bins?

Shailesh,

There are many resources available in the Learning section of the Tableau site. The usage of "Bins" are detailed in one of the videos here. Watch from 3:00

Hope this helps.

• ###### 2. Re: What is the concept of Bins?

Thank you so much Vishal. But I went through this video but need more simple example to understand and in this video they haven't mentioned how to create sets

• ###### 3. Re: What is the concept of Bins?

Shailesh,

Ah I thought you wanted to know about Bins as that is what you mentioned in your question. For a great answer about sets, please refer to Simon Runc's post here

2 of 2 people found this helpful
• ###### 4. Re: What is the concept of Bins?

Thank you so much Vishal Jethwa for your help ..... Great post by Simon Runc Thanks Simon....

1 of 1 people found this helpful
• ###### 5. Re: What is the concept of Bins?

Hi Shailesh, here's a rundown on bins, paying particular attention to the idea of a histogram:

http://www.statisticshowto.com/what-is-a-bin-in-statistics/

In terms of an example, consider order sizes in the Superstore data set. I want to look at the distribution of my orders in terms of value, using bins with a width of \$500. So I am looking at how many orders are there between 0 and \$500 in size, how many between \$500 and \$1,000, how many between \$1,000 and \$1,500 etc. I can see from the following chart that the vast amount of my sales are made up of smaller orders (between \$0 and \$500).

Note there's a few orders at the higher end of the scale not visible on this chart. Switch CNT(Sales) to SUM(Sales) and you'll see them. Also note that if this were not a drill, we would pay more attention to where our bin endpoints fall (not sure what Tableau default behavior is in this regard).

-- Glenn

4 of 4 people found this helpful
• ###### 6. Re: What is the concept of Bins?

Thanks Glenn... Awesome example. Now I understood ..

2 of 2 people found this helpful
• ###### 7. Re: What is the concept of Bins?

Glad it helped, Shailesh.

-- Glenn

2 of 2 people found this helpful