You need to sign in to do that
Don't have an account?
Ravi sastri
Fetch Previous Year's Records in Einstien Analytics
I have a requirement in **Wave Analytics** where I need to fetch records from Previous year when current year is completed. I have a field named Processing Year. It now fetches 2017 records which we have hard coded. But when we move to 2019, it need to fetch 2018 records. I have tried lot of options but nothing seems to be worked out.
Something like Current Year-1 will work.
Any help will be highly appreciated.
Thank you in advance
Something like Current Year-1 will work.
Any help will be highly appreciated.
Thank you in advance
You can use below format
Check below salesorce document for this.
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_date.htm
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.
Best Regards
Sandhya
Please help
Thank you in advance