You need to sign in to do that
Don't have an account?
Matty B
Wave Analytics Get Hours Between 2 Dates
I need to be able to calculate the number of hours between 2 date fields. In Wave Anlytics this doesn't seem to match with the available operators (COUNT, SUM, etc.).
I would think it should be able to be handled rather than importing this calculation in the actual ETL. Which approach should I be taking (SAQL or Compare tables or something else)?
I would think it should be able to be handled rather than importing this calculation in the actual ETL. Which approach should I be taking (SAQL or Compare tables or something else)?
Please refer developer guide page no 36 what date functions you can use.
https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_saql.pdf
Hope this helps you!
If this helps you mark it as solved.
Thanks and Regards
Sandhya