/profile-content.jspa?filterID=contentstatus[published]&targetUser=48261 Recent content in Tableau Community Forums en Mon, 01 Dec 2014 13:45:34 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-12-01T13:45:34Z en https://community.tableau.com/thread/152644 <!-- [DocumentBodyStart:b0f1989d-03b5-4b99-aefe-5b9a7396736c] --><div class="jive-rendered-content"><p>Hi forum!</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Newbie here, but really intrigued by this awesome product! This is my first discussion here.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I have a Dimension named "Description" with a long text string in it. I want to aggregate rows that <span style="text-decoration: underline;">contains</span> the word "Tableau", and rows that contains the word "IBM", and rows that contains the word "SAP". I have played around with Datasets, Filters, Calculated Field Wildcard search, and they all work superb but for only ONE word at a time. I tried the CASE logical formula, but I'm could only do predefined strings, not CONTAINS... Or can you. I'm not a black belt in CASE-formulas...</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>So the question is how can I set it up to give me all words at the same time in my visualization e.g. in a bar chart with one bar for each Tableau, IBM and SAP...</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Look forward to some insight on this one.</p></div><!-- [DocumentBodyEnd:b0f1989d-03b5-4b99-aefe-5b9a7396736c] --> calculation filter Mon, 01 Dec 2014 13:45:34 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/152644 2014-12-01T13:45:34Z 4 years 7 months ago 2 0