I have clients with multiple programs that customers could be enrolled in. For example, they could be enrolled to receive the weekly newsletter, a member of the loyalty program, a provider of feedback, etc. In some cases, there can be 6 or more of these types of programs. For a given customer ID, I have data indicating whether or not someone is a member of each program (yes or no).
What I'd like to show is two different things:
Any ideas how to do this? I know that Venn diagrams aren't part of tableau and multiple programs would make them impractical anyway, but that's the general idea that I'd like to get across: membership in a given program and overlap between programs.
Any advice would be welcome. I'll attach an example Excel doc with some dummy data so you can get a sense of what I'm looking at. I included two tabs. The first is the raw data and the second is reshaped for Tableau (but not sure this is necessary). This example has four possible programs.