Complex Binning

tableaucommunity@tableau.com — Fri, 21 Nov 2014 04:57:47 GMT

I have a data set where each product has a minimum size, maximum size, and KG of product sold. I want to first, distribute the KG of product sold between the minimum size and maximum size, and then show this on a distribution graph that shows the number of KG sold per each size.

So for example,

Product	Min Size	Max Size	KG sold
A	1000	2000	100000
B	1500	2000	150000
C	1000	3000	100500
D	1200	1700	240000
E	1900	2100	100100
F	1000	1100	100000

I want to be able to specify a bin size for the max and min size: e.g. 100 then calculate the kg sold per bin size

for example, with a bin size of 100, for product A there would be 10 categories, each with 10000 KG of products sold

There would be therefore 10,000KG of products sold each for sizes 1000-1100, 1100-1200,1200-1300,etc.

Is there a way to do this in Tableau?

Content in Tableau Community Forums

Complex Binning