Currently I have a dataset that is all opportunities.
I generated a dashboard and in there I have report/graph that is all the opportunities grouped by a field called channel__c
In salesforce I would have created a summary report and group by channel and then add formula field, that will look like this
RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)
However in wave I dont see this option, I am wondering is there a point and click like traditional salesforce report to do this or I need to add SAQL?
I have also try ammending my SAQL but I havent been able to get it right, as i keep getting an error: Unknown IDTOKEN: t
q = load "Opportunities"; q = group q by 'Channel__c'; t = foreach q generate count() as 't'; q = foreach q generate 'Channel__c' as 'Channel__c', count() as 'channelcount'; q = foreach q generate 'Channel__c' as 'Channel__c', channelcount/t as 'Count'; q = order q by 'Channel__c' asc; q = limit q 2000;