I am making polygons that represent storage containers. These polygons change their size based on the how much of the selected category take up the total space availiable. For one category this isnt too bad, but to make subcategories it seems to take a really huge number of lines. If you look at sheet one on my packaged workbook, you will notice the different category filters on the right for the age of the different storage areas. So what is visible is how much of the storage area is filled as well as roughly what percentage of that filled area is filled with different age categories. On sheet two, it shows the total percentage of the storage area filled as well as a selector for different types of inventories and how much of each one of those makes up the total filled area. Each different category on each sheet is a new layer of polygons, and those polygons will change size depending on the data.
What I want to be able to do is show how much of one category makes up another category. For example I want to be able to see how much of a storage area is filled with ARAW almonds in the >60 Days age category. I also would like the
polygon to change size based on how much of that new subcategory makes up the total filled area. The problem that I am running into is that for now it looks good when only looking at one category at a time, but if I want to make subcategories
for each possible combination it will take a very large number of polygons that I have to map out in order to show the new amount of space that the new subcategory. As of now when only having data for each category alone, the excel
file I am using takes up 29,000+ lines and if I were to make each possible combination for all the of categories and subcategories I would like to be able to see, I can easily see the file reaching several hundred thousand lines long. Is there away to make a formula in Tableau that can calculate the polygons for me based on the categories and subcategories that I select?