I'm trying to display a very simple pie chart that shows the breakdown of which of our contacts have emails addresses and which do not.
I created a formula checkbox field called 'Has Email?' which displays Y or N to denote if the contact has an email address.
In 'Series' I pick 'Has Email?', group by Equal Values.
In 'Data Values' this dropdown only shows a limited number of my fields, seemingly those with Y/N or number values. I just want to display the # of contacts.
Apparently I can't leave this field blank.
QuickBase help shows a pie chart with <Calculated Column> Summarized by (summed) but this doesn't help.