select name,COUNT(id) from vlocity_cmt__OrchestrationItem__c where ((vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='Clarity' OR vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='ECommerce') AND ( vlocity_cmt__State__c ='Ready' OR vlocity_cmt__State__c = 'Running' ) AND CreatedDate <LAST_N_DAYS:7) AND (Name ='Fiber Installation Completion' OR Name ='SAP Hardware Provisioning Completion - Router - POD' OR Name ='SAP Hardware Provisioning Completion - Streama - POD' OR Name ='SAP Hardware Provisioning Event - Router - POH' OR Name ='SAP Hardware Provisioning Event - Streama - POH' OR Name ='Fiber - Wait LeadId') GROUP BY Name
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter