Insight calculado de Personalização diária única

Parâmetros de objeto

• Nome obrigatório: DailyPersonalizationUniques
• Nome de API obrigatório: DailyPersonalizationUniques__cio

Expressão de percepção

SELECT 
   DATE_ADD(ssot__PersonalizationLog__dlm.ssot__RequestDateTime__c,0) as RequestDate__c, 
   APPROX_COUNT_DISTINCT(ssot__PersonalizationLog__dlm.ssot__IndividualId__c) as NumUniqueIndividuals__c,    APPROX_COUNT_DISTINCT(ssot__PersonalizationLog__dlm.ssot__PersonalizationRequestId__c) as NumRequests__c,
   APPROX_COUNT_DISTINCT(ssot__PersonalizationLog__dlm.ssot__PersonalizationId__c) as NumPersonalizationRequests__c,
   APPROX_COUNT_DISTINCT(ssot__PersonalizationLog__dlm.ssot__ContentObjectAPIName__c) as NumUniqueRecordTypes__c,
   APPROX_COUNT_DISTINCT(ssot__PersonalizationLog__dlm.ssot__ContentObjectRecordId__c) as NumUniqueRecords__c
FROM
   ssot__PersonalizationLog__dlm
GROUP BY
   RequestDate__c