You need to sign in to do that
Don't have an account?
Bob Allen
Performing Count on SAQL CoGroup and received error: Type check pattern of function count is expected to have one of: ' but received: .
Lead = load "Lead_Opportunities";
Lead = filter Lead by 'StageName' == "Closed Won";
VMS = load "StarOpportunities";
VMS = filter VMS by 'StageName' == "07b_Closed Won";
Result = group Lead by 'all' full, VMS by 'all';
Result = foreach Result generate count(Lead.'Id') + count(VMS.'Id') as 'Closed / Won';
Lead = filter Lead by 'StageName' == "Closed Won";
VMS = load "StarOpportunities";
VMS = filter VMS by 'StageName' == "07b_Closed Won";
Result = group Lead by 'all' full, VMS by 'all';
Result = foreach Result generate count(Lead.'Id') + count(VMS.'Id') as 'Closed / Won';