title: Tableau - Error when COUNT boolean T/F
body: <p>My goal here is to count the # of True, False and NULL per day using my boolean calculation. Next step would be to calculate the percentage of each T, F, N with overall day.</p>
  
  <p>Below is the visualization I would like to achieve but instead of blue dots, I would need the count of them in number.</p>
  
  <p><a href="https://i.stack.imgur.com/NjESI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NjESI.png" alt="enter image description here"></a></p>
  
  <p>Initially, I tried</p>
  
  <pre><code>IF [boolean] THEN 1 ELSE 0 END
  </code></pre>
  
  <p>But only changing from True to 1, False to 0 and missing the NULL - not counting:</p>
  
  <p><a href="https://i.stack.imgur.com/aN8X1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aN8X1.png" alt="enter image description here"></a></p>
  
  <p>I also tried different Calculated Fields to get the count of it but always getting the same error:</p>
  
  <pre><code>SUM(IF [Field]=TRUE then 1 else 0 end)
  
  COUNT(IF [Field]=TRUE then [ID] end)
  </code></pre>
  
  <p>ERROR: </p>
  
  <p><a href="https://i.stack.imgur.com/LbEAk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LbEAk.png" alt="enter image description here"></a></p>
  
  <p>Could someone please assist me with a Calculate Field or any other solution where I could get a count of T, F, and NULL that would also assist me with the percentage?</p>
  
  <p>Thank you</p>