2 Replies Latest reply: Feb 15, 2016 11:22 AM by pradeep t RSS

    Null handling

    Roisha Rani

      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.