Apex Code Development You need to sign in to do that
Don't have an account?
How to calculate monthly revenue difference using wave analytics
Hi Team,
I'm new to wave analytics.
Is there any way to calculate the monthly revenue difference of last year and current year of salesforce object data.
For example, I need to calculate (June 17’ Rev$ - June 16’ Rev$) + (July 17’ Rev$ - July 17’ Rev$) + (Aug 17’ Rev$ - Aug 17’ Rev$)….track for 12 months and display the result in wave dashboard.
Please do help...
I'm new to wave analytics.
Is there any way to calculate the monthly revenue difference of last year and current year of salesforce object data.
For example, I need to calculate (June 17’ Rev$ - June 16’ Rev$) + (July 17’ Rev$ - July 17’ Rev$) + (Aug 17’ Rev$ - Aug 17’ Rev$)….track for 12 months and display the result in wave dashboard.
Please do help...
The answer is yes. Have you looked at using compare tables with SAQL?
You should be able to get at what you need using this feature.
Hope this helps.
Thanks,
Nagendra