HI Koushik ,
see this posts it will help you:
Filter to Business Days.twbx 410.4 KB
1 of 1 people found this helpful
thank you for the quick response.
For suppose, if we have national holidays on 5,11,18,24 this month. which calculation suits me the best?
can yu help me out. I need just one calculated field so that I should apply above logic( everytime)
4 of 4 people found this helpful
Please find the attached file which contains the desired result. However I have created it based on the parameter since I don;t have any transaction data for this month/ today. You can replace the Date parameter with today function when you are implementing it in your data.
Please update the Holiday tables with date and name of holiday. You can see I have excluded the holiday. (I have only mentioned Dec-25 as a holiday in the table.)
I have also created the parameter which take how many days back do you want to go. Your question would be in parameter 7 I have put 7 as a input but you are able to see only 5 days. Its because you need to write a condition for holiday for the same. I have no idea how to write it.
But for now this would be a good solution to your problem. Experts in the tableau community may have different perspective to the problem. Experts please take it further from here.
Thanks and Regards,
Thanks a ton ashish.
Mark answer as correct if that has helped and solved your query so that others can refer to this thread.