Need your help on below mentioned query.
Currently i am using below mentioned Calculated field to get TAT (Excluding Weekend ) which is working file. But i also want to exclude the Holidays.
IF [Description] = 'Creation Date' THEN
TODAY()-DATE([Reopen Time]) - ((ceiling(max(0,datetrunc('week',TODAY(),"Sunday")+1 -datetrunc('week',DATE([Reopen Time])+6,"Sunday"))/7))
(ceiling(max(0,datetrunc('week',TODAY(),"Saturday")+1- datetrunc('week',DATE([Reopen Time])+6,"Saturday"))/7)) )
If suppose i need to exclude 22/06/2019 and 25/06/2019 as holiday, then how i will arrive on this.
Find attached threads on this topic
FAQ: Holidays & Workdays /external-link.jspa?url=https%3A%2F%2Fkb.tableau.com%2Farticles%2Fhowto%2Fcalculating-the-number-of-business-days-in-a-month
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...