14 Replies Latest reply: Feb 10, 2017 9:05 AM by Vineeth Pujari RSS

    handling nulls

    Joanna Seldon

      Hi

       

      loading in two SQL tables

       

       

      Table 1 - Survey - Names the surveys the customer has completed

      Table 2 - Main - Main Customer Table

       

      when I load in these two sql tables, some CustomerID wont have completed a survey, and survey name appears as null - as expected

       

       

      I have working Count(if([SurveyName]=0,[SurveyName])) on a table chart. , this limits the CustomerIDs that have not completed a survey

       

      However I want to be able to count how many CustomerID, that have a Survey Name as null in a KPI

       

      with something like

       

      Count(if([SurveyName]=0,[SurveyName])) CustomerID)

       

      but it does not work

       

      I have tried too replace the nulls so they are selectable with no joy

       

      SET NullValue = 'No Survey'

       

      NullAsValue "SurveyName"

       

      please help