Visual Help - Multiple Columns

[sthomas38]

Hello,

 Please could you give some ideas on how to create this visual?

I have a dataset -

ID IssueA IssueB IssueC IssueD

1       1             0            0              1

2       1             1            1              1

3       1             0            0              0

4       0             0            0              1

5       0            1             1              1

6       0            0             1              1

I want an easy visual to show that

IssueA  IssueB IssueC IssueD

3                  1              1              2

IssueB   IssueA IssueC IssueD

2                    1              2            2

IssueC   IssueA IssueB IssueD

2                    1              2            2

What I have in mind is, User picks the first Issue from a list - Example IssueA, and then three of the other issues populate in a bar chart (IssueB=1; IssueC=1;IssueD=2), then user can pick IssueB from the chart and the other three Issue are in the bar chart, if there is 0 count, then it doesn't show at all.

Is this possible?

[dethompson97]

What is the correlation between the two?  I am not seeing how you are deriving the bottom desired visual from the top dataset.  Can you provide a little more detail?

Dawn

[sthomas38]

Sure,

So if User pics IssueA, then we look at how many IDs have a 1 for IssueA - which is 3

Looking at those three only - Total count for IssueB=1; IssueC=1 and IssueD=2

Does that make sense? Let me know please.. Thank you.