Huge number of null values resulting in a broken field filter?


I am having problems with one of my field filters that should automatically turn into a category one but keeps being a none type of field filter. The column we chose is called CompanyName and it has a total of 55 different possible company names. I wanted to know if a huge number of null values in the table on the column chosen to create this filter could in fact explain this problem. Also, these values are never related to a date.

Have a nice day !

Hi @aterrien
Please post "Diagnostic Info" from Admin > Troubleshooting.
It should not make a difference, since the scan query make a select distinct ...
But make sure that you manually set the field to "Category" in Admin > Data Model.

Hi @flamber,

Thanks for your answer, that was exactly what I needed. Our integrator got that going for us and it seems to have help get rid of this issue.