
1. Re: How can I calculate range penetration %?
ailsa.zheng Sep 10, 2015 2:02 PM (in response to Mitchell Gulbransen)Hi Mitchell,
Here is the calculated field for measure 1's penetration:
(attr([Measure 1])WINDOW_MIN(min([Measure 1])))/(WINDOW_MAX(max([Measure 1]))WINDOW_MIN(min([Measure 1])))
Replace Measure 1 with Measure 2 for measure 2's penetration. I put measure 1 on the first sheet and measure 2 on the second.

Mitchell.twbx 15.9 KB


2. Re: How can I calculate range penetration %?
Mitchell Gulbransen Sep 11, 2015 7:14 AM (in response to ailsa.zheng)Unfortunately, I am running Tableau 8, so I couldn't view your sample workbook, but thanks for your quick response!
I tried your calculation above and it did not return results with my current data setup. I then changed the ATTR([measure1]) SUM([measure1]), and I got closer, but the values don't look correct.
What I am ultimately struggling with is how to create a common range so a color scale can be applied for a heat map without skewing towards the measures that naturally have higher values. This requires comparing the SUM of the measures by month to the MIN and the MAX of the full set of measures  I have yet to have success with this.
Viz purists, not to worry, this is a shortterm solution until we can get a more Tableaufriendly tall data structure, but for now, this is what we have to work with. I have attached a screenshot of a mockup of what our source data looks like (with randomized underlying data) for the time being, as well as my unsuccessful attempt to get range penetration %, displayed here in a table with two measures just to see if the calculation was looking right (which it was not)

3. Re: How can I calculate range penetration %?
ailsa.zheng Sep 11, 2015 4:11 PM (in response to Mitchell Gulbransen) 
4. Re: How can I calculate range penetration %?
Mitchell Gulbransen Sep 14, 2015 6:51 AM (in response to ailsa.zheng) 
5. Re: How can I calculate range penetration %?
ailsa.zheng Sep 14, 2015 9:17 AM (in response to Mitchell Gulbransen)It looks like it's calculating using Table Down instead of Table Across, because if it's not getting results at all it might be doing this for February:
(4335)/(4335)
Instead of (4340)/(5540)
Can you go to Edit Calculation and then play with the Calculate Along?

6. Re: How can I calculate range penetration %?
Mitchell Gulbransen Sep 14, 2015 9:30 AM (in response to ailsa.zheng)