I have an input file that gives me the following data -
ID | Test 1 | Test 2 |
A1 | Y | Y |
A2 | N | Y |
A3 | Y | N/A |
A4 | N/A | N |
A5 | N | Y |
A6 | Y | N/A |
Below is my desired output in Tableau with colors for conditions based on counts in each column....
Y | N | N/A | |
Test 1 | 3 | 2 | 1 |
Test 2 | 3 | 1 | 2 |
Go to Data Source Tab and Select Test1 and Test2 columns and click on pivot option:
Your data will look something like below Screenshot :
Go to sheet and create below view:
Hope this helps!!
Become a Viz Whiz on the Forums! Support the Community and master Tableau.