How to get bar chart with distinct count based on a column in tableau?
<p>I have the following data:</p>

<pre><code>Name, Sport, Random Number
John, Tennis, 4
Jacob, Tennis, 4
Jacob, Tennis, 2
Jacob, Football, 5
</code></pre>

<p>I want to show a bar chart that counds up the number of People playing Sports.</p>

<pre><code>X Axis: "Sport"
Y Axis: "COUNT(Number of Records)"
</code></pre>

<p>My current tableau is set as this:</p>

<pre><code>Rows: Name
Column: SUM(Number of Records)
</code></pre>

<p>I want the bar graph to reflect the "Count of DISTINCT names who play the sports".
My problem with the above is that the "Tennis" for example has a count of 3 instead of 2. How do I make it so that the bar shows up as 2?</p>