I used the Tableau bin feature to slot my data.  I calculated the years of service within tableau as well.  My years of service calculation basically takes the difference between 2013 and whatever the year value is in an EE's service date.  So they are all integers.  Hourly rate came from an external source that I pulled into Excel.  I created a datasource in Tableau to my Excel data.

I do not think this is working as I would like.  I see you are using only one bin (Sales), but Customer Segment is a Dimension, rather than a bin.  An analogy using your data would be to create bins on Sales and Profit, replace the customer segment pill with the Profit (bin) pill, and then calculate an average profit within each sales bin.

of course if I'm mis-interpreting your solution, then perhaps I'm not nearly as good with Tableau as I think I am.

To clarify:  using your technique, I can get some data to match my expectations.

for example, when I use the following formula:

window_sum(sum[hourly rate])

computed using pane (across then down), I get the sum of all hourly rates within the years of service bin, just as I expect.  but when I change the formula to either:

window_avg(sum([hourly rate])    or  window_avg(avg([hourly rate])

I don't get answers anywhere close to what I'd expect.

I've attached a packaged workbook using storefront that has a layout somewhat like what I've created in my own data.

Note that I've created a Sales bin that segments sales into groups by 15K intervals and that I've created a Profit bin that segments Profits by $500 intervals.  I'm showing counts of how many rows have profits (by bin) within sales (by bin).

I'm trying to calculate average profit across the profit bins within each sales bin.  Sheet 2 has the profit value I'm trying to get to within each sales bin.  I'm wondering if there is some way to calculate the values in sheet 2 using the viz showing in sheet 1.

Hopefully this makes more sense?

Hi Alex - sorry for the delayed response, I was swamped yesterday.  I implemented the formula as you describe, applying it to my situation and it is not producing the result I expect.  For whatever reason, I am still not getting an average hourly rate that matches what I calculate in Excel.  It's a very confusing thing.  Unfortunately I can't post my data, and perhaps I did not accurately create the analagous sitatuion in storefront, but the expected results do not jibe.

In looking over the formula, I had an overall question - why use TOTAL of AVG?  I would have thought that this would give me the average for each sub-bin within Profit and then totaled those averages within each Sales bin.  Am I not understanding that formula correctly?

SUCCESS!  THANK YOU!

I was using the average from the calculated field, rather than using the Average of my hourly rate field.  When I modified to follow what you had done, I got the results I was expecting.  THANK YOU.

Now can you please expalin (in very simple terms, cause apparently I'm a doof) exactly why/how this works?

Thank you.  That explanation helped, though I'll still need to work through it in my head to "get it".

Table Calcs and Partitions still remain a total mystery to me at times.  I am really hoping that one day someone will offer a course that focuses exclusively on how these things work.  Even the advanced course kind of skims over the intricacies of table calcs.  Frankly, I see a lot of potential for data processed in Tableau to be mis-interpreted because people are so used to the point-click-drag-drop simplicity of the product that they don't think about the results of the answers Tableau is providing.  They may be correct answers but they may not be the "right" answers.