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.

This is how the current report looks in salesforce: enter image description here

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?


create a compare table and make what ever groupings you need, create the new formula based columns in your table to calculate percentage or complex calculation. you can post your use case here, i can help you building the SAQL query.

for more reference

https://www.youtube.com/watch?v=ePvDXx5SFpU https://help.salesforce.com/articleView?id=bi_explorer_compare_table.htm&type=5 http://www.mstsolutions.com/blog/content/performing-calculations-wave-analytics-using-compare-table https://www.jitendrazaa.com/blog/salesforce/salesforce-wave-analytics-cloud-compare-and-data-table-video/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.