
1. Re: How can I link Date subtotals from the same table?
jordan.bunker Mar 20, 2014 9:25 AM (in response to Jacob Fink)Hi Jacob,
You could use a table calculation for this I would start with something like the following:
WINDOW_SUM(COUNT([Account Open Date]))WINDOW_SUM(COUNT([Account Close Date]))
This calculation sums all of the open dates in the viz, and subtracts the sum of all close dates in the viz from it.
Table calculations are meant to further aggregate already aggregated data, which is exactly what the above calculation is doing. For more information on using and understanding table calculations, I recommend the following resources:
Table Calculations
http://kb.tableausoftware.com/articles/knowledgebase/TableCalculations
Table Calculations (VIDEO)
http://www.tableausoftware.com/learn/tutorials/ondemand/tablecalculations0
Advanced Table Calculations and Formulas (VIDEO)
http://www.tableausoftware.com/videos/advancedcalculations
Making Table Calculations work in Tableau
http://www.theinformationlab.co.uk/2011/12/07/makingtablecalculationsworkintableau/
Want to Learn Table Calculations? Here's How!
http://drawingwithnumbers.artisart.org/wanttolearntablecalculations/
Hope this helps!
 Jordan