Calculate Week Days between two Dates in Wave Einstein analytics (SAQL)

Requirement: a SAQL query to find the number of WEEKDAYS between two dates. Specifically, can use this SAQL query in a Compute Expression SAQL Expression: Here dataset name is “cases”. Start date is Created Date of a Case record and End Date is ClosedDate of Case. Algorithm is copied from here: https://help.salesforce.com/articleView?id=000004526&type=1. q = load “cases”; q = …

Calculate Week Days between two Dates in Wave Einstein analytics (SAQL) Read More »