I've come across another issue in Tableau. I am trying to count the number of working days between two dates. I used the following calculation which works, however it still includes holidays.
([Date Complete]-[Date Received])-
if
(DATEDIFF('year',[Date Received], [Date Complete]))>=1
then
(2*((DATEPART('week', [Date Received]) + 52*DATEDIFF('year',[Date Received], [Date Complete])) - DATEPART('week', [Date Received])))
else
(2*(DATEPART('week', [Date Complete]) -DATEPART('week', [Date Received])))
end
I also have another data sources I have connected to that determines business days and holidays, but I'm not sure how to successfully connect the two sources.
There are some other threads on this Forum that are related, not sure what may help you here (didn't view your workbook) but here's one that may be of use:
The specified item was not found.