There is missing or null values as well in the column. Requirement is to define null values or missing values to ' NA' Category. I have used below expression for this in my script while loading Category field.
If(Len(Category)=0 OR Category='','NA', Category) as Category.
But still I could see blank values in the Category legend of my chart. Could you please help me in this.