Esempio: Casi chiusi per tipo di interazione

Utilizzare questo esempio di SQL per la percentuale e il totale dei casi chiusi per tipo di interazione.

In questo esempio, sostituire il testo in grassetto con i nomi dei campi API del DMO di chiusura del caso.

SELECT <Cases__dlm.ClosedDate__c> AS ClosedDate__c, SASearchInteractions__dlm.InteractionType__c AS InteractionType__c, APPROX_COUNT_DISTINCT(<Cases__dlm.CaseId__c>) AS CasesClosedWithInteraction__c, APPROX_COUNT_DISTINCT(<Cases__dlm.CaseId__c>)/MAX(SubQuery.TotalCasesClosed__c) * 100 AS PercentOfCasesClosed__c FROM <Cases__dlm> LEFT JOIN (SELECT <Cases__dlm.IsClosed__c> AS IsClosed__c, APPROX_COUNT_DISTINCT(<Cases__dlm.CaseId__c>) AS TotalCasesClosed__c FROM <Cases__dlm>  WHERE <Cases__dlm.IsClosed__c> = TRUE GROUP BY <Cases__dlm.IsClosed__c>) SubQuery on <Cases__dlm.IsClosed__c> = SubQuery.IsClosed__c LEFT JOIN SASearchResults__dlm ON <Cases__dlm.CaseId__c> = SASearchResults__dlm.RecordId__c LEFT JOIN SASearchInteractions__dlm ON SASearchResults__dlm.ResultId__c = SASearchInteractions__dlm.ResultId__c WHERE <Cases__dlm.IsClosed__c> = TRUE AND SASearchResults__dlm.RecordId__c IS NOT NULL AND SASearchInteractions__dlm.ResultId__c IS NOT NULL GROUP BY <Cases__dlm.ClosedDate__c>, SASearchInteractions__dlm.InteractionType__c