I am working on SAQL to find Percentage of Leads that has been converted into opportunities.
I am working on wave-utils to check my SAQL and I am receiving the following error:
Cogroup projection idtoken requires stream identifier: 'converted'
The following is my code
q = load "ABCLeads"; a = group q by all; a = foreach a generate count() as 'total'; q = group q by 'Converted'; b = filter q by 'Converted' == "true"; b = foreach b generate count() as 'converted'; d = group a by 'total', b by 'converted'; c = foreach d generate round ((('converted')*100)/'total') as 'total_percent';
Is there any other better way to perform the above?