What I'm trying to do is create a set of bins based on a calculation. As a watered down example I have 3 fields in my data:
First I sum the EnquiryCount over the time period for each listing id - which gives me the total enquiry count for each ListingId. I want to use this value for the bins.
It's simple to create a calculated field summing the EnquiryCount (EnqCountCalc in the attachement) then create another calculated field creating the bins (EnqCountBins).
From this I'm able to count the number of listings in each EnquiryCount bin as long as I have the ListingId on the level of detail shelf.
What I want to be able to do, and where I'm running to problems, is create a histogram showing for each bin the % of total enquiries over the time period which happened in the month.
The sheet in the attachment HistogramNoBins shows what I'm trying to achieve but I'd like this with the bins along the X axis. My attempt, which doesn't work, is in the sheet %EnqsPerMonthPerBin. The total should be 100% for all bins but with the ListingId in the level of detail this doesn't work.
I tried to use a Window_sum table calc, computing using the ListingId (WindowSum in the attachment) - but this also doesn't work as it needs the ListingId in the level of detail.
Is this even possible using Tableau? I think I can do this using custom SQL and summing the EnquiryCount before bringing the data into Tableau but that's quite time consuming to process the data beforehand (in reality the dataset is large) and doing it in Tableau seems much neater.
The attached Excel is just some dummy data to feed the workbook, it's actually a SQL feed that will be going into this - and it has to be an extract for performance reasons as the data takes over 30 mins to pull from SQL.