How do you give a Yes/No field in Chart text names instead of 1/No

I've created a Chart where there is a Yes/No field called PAID where I want to show the Data separated depending on if it is a Yes or a No. However on the Chart is shows up as a 1 or the work No so the data is displaying the way I want. However instead of the "1", I'd like it to be a "Yes" so it is intuitive to the user. 

Can this be done?

2 replies

    • checkyourmirrors
    • Matthew_Moran
    • 4 mths ago
    • Reported - view

    I figured this out and it was due to the field being "Null" so I updated the Default value to No and also bulked edited all the existing data to set to No if it was Null and all is good now.

      • John_Halls
      • 4 mths ago
      • Reported - view

       This is an important point regarding 'Yes / No' fields. Unless a default value of 'Yes' or 'No' is set the value will be null, not what you would expect from a 'Yes / No' field. 

Content aside

  • Status Answered
  • 4 mths agoLast active
  • 2Replies
  • 48Views
  • 2 Following