處理空值數值

已計算資料欄的 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
            }