I am using the calculation below to find the percent of days remaining in the month. I use all weekdays in my data and would only like to exclude bank holidays. Is there a way to do this?
day(dateadd('day', -1, dateadd('month', 1, datetrunc('month', today()))))
The FAQ here goes through several questions and what is and what is not possible with some crafty calculated fields.
FAQ: Holidays & Workdays
Best of luck
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...