Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have Category field in my Dashboard.
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.
Try this for handling and showing blank values as NA in chart
=if(len(trim(Category))=0,'NA',Category)
you can also try this in script...
SET NULLVALUE ='NA';
NULLASVLUE Category;
Load Field1, Field2, Category from File;