/profile-content.jspa?filterID=contentstatus[published]&targetUser=40723 Recent content in Tableau Community Forums en Mon, 07 Aug 2017 13:05:48 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2017-08-07T13:05:48Z en https://community.tableau.com/thread/145396 <!-- [DocumentBodyStart:22a284f4-7cb1-470e-8494-670d4b643e44] --><div class="jive-rendered-content"><p>Is that possible? How to do? When i open a Excel data source, i dont see Custom SQL option.</p></div><!-- [DocumentBodyEnd:22a284f4-7cb1-470e-8494-670d4b643e44] --> custom sql excel Mon, 07 Aug 2017 13:05:48 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/145396 2017-08-07T13:05:48Z 1 year 11 months ago 8 0 https://community.tableau.com/thread/145639 <!-- [DocumentBodyStart:b70fcf58-c015-4554-911d-cf6e04855c3e] --><div class="jive-rendered-content"><p>Hey guys.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Take a look at this table:</p><p><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-283778-19052/Captura+de+tela+2014-07-09+14.20.53.png"><img alt="Captura de tela 2014-07-09 14.20.53.png" class="image-1 jive-image" height="710" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-283778-19052/Captura+de+tela+2014-07-09+14.20.53.png" style="height: 431px; width: 620px;" width="1022"/></a></p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>How to make the total sum only the valid values? Like in the model from Andrew Chen?</p><p><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-283778-19053/ChristophJanz_CohortAnalysisNotes.0021.png"><img alt="ChristophJanz_CohortAnalysisNotes.0021.png" class="image-2 jive-image" height="768" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-283778-19053/ChristophJanz_CohortAnalysisNotes.0021.png" style="height: 465px; width: 620px;" width="1024"/></a></p><p>References:</p><p><a class="jive-link-external-small" href="https://community.tableau.com/external-link.jspa?url=http%3A%2F%2Fandrewchen.co%2F2013%2F10%2F24%2Fthe-easiest-spreadsheet-for-churn-mrr-and-cohort-analysis-guest-post%2F" rel="nofollow" target="_blank">http://andrewchen.co/2013/10/24/the-easiest-spreadsheet-for-churn-mrr-and-cohort-analysis-guest-post/</a></p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks guys!</p></div><!-- [DocumentBodyEnd:b70fcf58-c015-4554-911d-cf6e04855c3e] --> calculation cohort cohort_analysis Mon, 20 Jul 2015 14:18:18 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/145639 2015-07-20T14:18:18Z 3 years 11 months ago 13 0