Content in Tableau Community Forums /profile-content.jspa?filterID=contentstatus[published]&targetUser=31884 Recent content in Tableau Community Forums en Fri, 31 Jan 2014 05:15:33 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-01-31T05:15:33Z en Keeping Window_sum calculation unchanged while change range of date https://community.tableau.com/thread/138345 <!-- [DocumentBodyStart:4e05b691-6791-41da-bd78-35680efb0da2] --><div class="jive-rendered-content"><p>How can I keep the window_sum calculation (a lagged sum along the date dimension, say sum of previous 3 months' data) unchanged while filtering with dates?</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Currently the first two months of calculation would go off whenever I filter by date.</p><p>Is it doable within Tableau or should I just do the calculation in my Custom SQL query then pull the field in so Tableau doesn't do the calculation? </p></div><!-- [DocumentBodyEnd:4e05b691-6791-41da-bd78-35680efb0da2] --> filtering window_sum date_filter window_functions filter_criteria Fri, 31 Jan 2014 05:15:33 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/138345 2014-01-31T05:15:33Z 5 years 5 months ago 6 0