You will have to use a calculated field to generate the bins to accomplish what you are looking for.
I have attached a workbook (10.2 since that is what your question was about), but the calculations are below as well. In the work book I used sample super store and the profit field. Look at sheet 2 and notice how the bin size changes as you change the Profit filter, Note that the Profit filter has to be a Context filter because of Tableau's Order of Operations.
Hope this helps!
CustomBins.twbx 1.2 MB
Thanks Jay. Your answer is helpful in seeing how the filtering works, but it requires using a fixed number of bins. Is there a way to still get the functionality that Tableau offers to suggest a number of bins, after the data have been filtered?
2 of 2 people found this helpful
I can't believe this escaped me before, I partially misunderstood what you were looking for.
for number 1:
use a calculated field as follows, instead of your numeric data field
[Numeric Data for bins] =
if [Numeric Data] < 100 then Null else [Numeric Data] end
This should give the behavior you are looking for for suggested bin size.
For number 2 I am not sure I quite understand what you are looking for any chance you can post a sample workbook?
Thank you, Jay. This actually answered my second question as well, and was exactly what I was looking for.
I appreciate your help as I get started with Tableau.
Great! glad I could help.
Please mark the correct answer to close out this thread and help any one who happens by with a similar question in the future.