title: tableau: creating bins for variable bound between 0 and 1
body: <p>I have just started using Tableau and I have run into a problem. I want to create a histogram of the percentage of loans that have not been paid back. I created a variable called 'Delinquent num' coding the loans that have not been paid back as 1 and all others as 0. Then I calculated the percentage of loans that have been paid back (Delinquent pct) as (SUM([Delinquent num])/COUNT([Delinquent num]))*100. </p>
  
  <p>I entered this variable on the sheet as the Rows variable and got </p>
  
  <p><a href="https://public.tableau.com/views/project3_working/pctDelinquent?:embed=y&amp;:display_count=yes" rel="nofollow noreferrer"><img src="https://public.tableau.com/views/project3_working/pctDelinquent?:embed=y&amp;:display_count=yes" alt="Screen shot"></a></p>
  
  <p>That is fine; about 18% of the loans go bad. But now I would like to make a histogram. That choice is not highlighted in the "show me" menu. I tried to create a 'bins' variable from the pull down menu from the variable itself but the option to create bins is not offered for the variable I created and I don't know why. Creating bins is offered as a choice for the Delinquent num but since everything is either a 0 or a 1 in that variable a histogram would not be terrible useful. Any suggestions? </p>
  
  <p>Here is a link to the public notebook if that would be useful. </p>
  
  <p><a href="https://public.tableau.com/views/project3_working/pctDelinquent?:embed=y&amp;:display_count=yes" rel="nofollow noreferrer">Project3_working</a></p>