maybe if I provide the result expected, It will be clearer.
For the given input, the output should be smth like:
By & I mean the set intersection. So in case of B&C - there are 2 IDs that have BOTH, attribute B AND attribute C.
Does this explain better what I want to achieve?
1 of 1 people found this helpful
The first thing which comes to mind is this thread Creating the equivalent of a Venn diagram? which has an answer provided by Joe Mako. I've used his solution here (Venn alternative using custom SQL).
There has been an idea created for Venn diagrams (http://community.tableau.com/ideas/1582) and in the comments there, Jonathan Drummey has shown a good work around (his workbook is here: http://public.tableausoftware.com/profile/jonathan.drummey#!/vizhome/vennalternatives/customSQLbasicbar).
For a different method which may fit your purpose (depending upon how you want to display the results) have you looked at Bethany Lyon's fantastic Think Data Thursday video on Sets (at the bottom of this list:TDT Video Library - Old)? It's really worth watching the whole lot but about half-way through she talks about creating sets for different attributes and showing how many times different attributes occur together.
thanks a lot. I think I will be able to work this out from the video. Though I am not sure, where to find the workbook (in video she says that it will be uploaded, just I don't know where).
Regarding Venn diagrams and workarounds. Yes, this is exactly what I am interested in. However, since I am using Mac OS, the custom sql solution is not really an option for me (apparently neither is the extract api, which also does not work with Mac OS).
Anyway, thanks for a useful reference to the video.
the expected outcome is not like that. Or at least not entirely. Because I am interested in intersection, not only presenting complete sets of Attributes, that particular ids have.
The workbook is available here:
I don't think Joe's solution used custom SQL. It's basically a calculation based on a CASE statement so that might work for you.
yes this is more like it.