Skip navigation

1 Reply Latest reply on Jul 14, 2018 8:10 AM by Padma Yalavarthi

Summary of Multiple Columns

Subba Rao Jul 13, 2018 2:48 PM

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

1. Re: Summary of Multiple Columns

Padma Yalavarthi Jul 14, 2018 8:10 AM (in response to Subba Rao)

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!!
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

More Like This