I'm at best an advanced novice, have encountered a somewhat sticky problem I'm hoping for some insight on. In an attempt to calculate business days excluding holidays, I created a physical join as below:
I was able to add some calculated fields to my worksheets that accurately excluded both weekends and holidays using this method, and have been able to perform calculations on those results using a fixed LOD.
The problem, however, is that when I try to count the total records, I'm getting an individual iteration for each of them for every holiday that occurred during the period they were in process. Please forgive my lack of experience, but I've tried several versions of an exclude LOD (basically {EXCLUDE [business days calculation] : COUNTD [entries] } and the system is still counting one distinct entry for each holiday when I add it to the visualization.
Am I using the exclude LOD incorrectly, or is this effectively an unsolvable problem due to the nature of the physical join above? Something else that my limited experience/native capacity has yet to even consider? Thanks in advance for any insight on this, I'll be sure to pay it forward as my skills improve.
so if I understand you have used a calculation (which you are not showing) to exclude weekends and holidays and then you made it an LOD which you are also not showing - and you are getting a bad result - (you should know if you are counting records and there are duplicates in the data set it will count them both)
Please post your workbook as a twbx so we can see what you did and what it returned -
it is much easier for you to create a workbook even with fake data than for us to try to recreate the problem -
Thanks
Jim - Tableau Visionary
