处理空数值

计算列的 defaultValue 属性接受空值。例如：

"SAQLNode": {
      "action": "computeExpression",
      "parameters": {
        "source": "extractOpp",
        "mergeWithSource": true,
        "computedFields": [
          {
            "name": "Amount2",
            "type": "Numeric",
            "precision": 18,
            "defaultValue": "null",
            "scale": 5,
            "saqlExpression": "Amount+Amount"
          }

计算列的 defaultValue 属性接受空值。当无法计算值时，例如当previous()或next()没有值时，CRM Analytics 会使用此默认值。例如：

"computeTrending": {
        "action": "computeRelative",
        "parameters": {
            "partitionBy": ["OpportunityId"],
            "orderBy": [
                {
                    "name":"CreatedDate", 
                    "direction":"asc"
                }
            ],
            "computedFields": [          
                {
                    "name": "AmountPrev",
                    "defaultValue" : "null",
                    "expression": {
                        "sourceField": "Amount",
                        "offset": "previous()",
                        "default": "null"            
                    }       
                }

measureDefault 参数接受空值。CRM Analytics 会在无法将维度转换为有效数值时使用此值。在未指定默认值时，CRM Analytics 会使用空值。例如：

"Create_Measure_From_Dimension": {        
      "action": "dim2mea",        
      "parameters": {            
         "dimension": "StageVal__c",            
         "measure": "StageValue",            
         "measureDefault": "null",                      
         "source": "Extract_Opportunities"        
      }    
   }

列的 defaultValue 属性接受空值。在未指定默认值时，CRM Analytics 会使用空值。例如：

Sample Sfdc-digest :{    
   "Extract_Opportunities": {        
      "action": "sfdcDigest",        
      "parameters": {            
         "object": "Opportunity",
         "fields": [                
            {
               "name": "Amount",
               "defaultValue": "null",
               "precision":18
               "scale":2
            }