You can put "Owns Brand Product" on the Rows Shelf, and "Perception of Brand" on the Columns Shelf.
That will give you this view:
(If you get something different, use the "Show Me" button to switch to Table).
Next step is to drag the "Perception Brand" pill from the left (Data) column to the Marks Area, on the Text Square.
The result looks wonky, I give you that:
Next step is to change a few settings:
Hover over the "Perception of Brand" pill on the Marks card, to see the down arrow appear, then select Measure and Count
Which gives you a count of each response, like so:
You are almost there. The last step is to use a table calculation to find the % of total per row:
On the same pill that we just changed to "Count", we are now going to select Quick Table Calculation/Percent of Total
And the table is ready:
Please let me know if this works for you, or if you have any other questions!
Nick Question %.twbx 19.8 KB
Yes that helps thanks you.
Additionally, if I just wanted to include "Great" or the total % of "Great" + "Good", is there a calculation I can create to do that?
How can I get a count and % of total of a specific value?
In that case you would create calculated field (double-click in the Analysis sidebar), to create your new values.
You can change the If statement as needed.
Now drag your new Dimension/blue pill on the Columns Shelf, where you have "Perception of Brand" and remove the original Perception of Brand pill.
If you wanted to only show the percentage of Great + Good, you can hide the OK and Poor column.
Which gives you this:
I am attaching a packaged Tableau Workbook, where you can look at everything I did.
If this is helpful, feel free to mark your question as closed, if you need more, feel free to ask more!
Nick Question %.twbx 21.8 KB
This is incredibly helpful! I often use Tableau to analyze survey data, which has text-based values (ex: select one from a drop down).
This simple calculation will be invaluable going forward for getting a count of a specific number in a table format.