3 of 3 people found this helpful
Suppose you have Data as in the below xlsx
When you connect your xlsx data from Tableau , after connecting you will get the below screen . Click on "Manage metadata" as shown in the screen below
Thereafter you get the below screen , select on all the fields using "ctrl" and rt click and click on "pivot" ( see screen below )
As a result you will get pivot field names and pivot field values as below ,
Now go to your work sheet , put pivot field name and pivot field values in columns and the number of records in Rows , to get the bar graph
You can finally drag the pivot field names into color to get the visualization you are expecting. If this resolves the issue , mark this question as answered so that the question does not remain unanswered and is available to other users. Let me know if you still have any questions / concern.
Thank you so much for taking the time to explain this to me. You have saved me so much time and sanity.