How to Include the Weekends and Public Holidays in the OTBI dashboard

Summary:

How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):

case when "HR Help Desk Request Milestone"."Completion Date" is not null then
TimeStampDiff(SQL_TSI_DAY,"HR Help Desk Request Milestone"."Completion Date","HR Help Desk Request Milestone"."Due Date")
else TimeStampDiff(SQL_TSI_DAY,CURRENT_DATE ,"HR Help Desk Request Milestone"."Due Date") end