I am trying to recreate a report into analytics, and I am not really sure how to make it look the same (in terms of information) as a traditional salesforce matrix reports that contains formulas.
And the formula is based on the grouping total and not the grand total (181)
The closest I can get in analytics is making the table as pivot, but how can I add in there the percentages, and the extra column?
I am not very familiar with Analytics yet, but it seems the only way is through SAQL?
if so, the current SAQL of the report is:
q = load "BF"; q = group q by ('Referrer_Account_Name__c', 'Bucket_Stage__c'); q = foreach q generate 'Referrer_Account_Name__c' as 'Referrer_Account_Name__c', 'Bucket_Stage__c' as 'Bucket_Stage__c', count() as 'count'; q = order q by ('Referrer_Account_Name__c' asc, 'Bucket_Stage__c' asc); q = limit q 2000;
Or do i need to split this into different reports?