I have a number of custom fields. Quite a lot of them are yes select option answers. However a number of contacts have what I think is a null value in them.
So if I search give me everyone who has a yes in the field answer I get the answer 579 for example. If I search is not null I get a much higher value eg 1179.
Does anyone know where his data comes from and what it is? If I get rid of it will it just come back?
The reason I am asking is that I am building a chart in Views where I want to display multiple custom fields in a bar chart. As I am trying to display multiple values I can't filter the data for each custom field rather I am relying on the fact that there is data in the field at all to act as the filter and to ensure an accurate count.
I hope I have explained myself properly!
Thank you!