Temeraire book 17/6/2023 ![]() ![]() to stop us getting a count of 6 working days when looking at Sunday through to Saturday, the datepart snippet is wrapped in a ‘min’ calculation with the number 5 so we get no more than 5 working days in a week. This means if we take away the weekday number from 7 we will get the number of days up to Saturday. ) / 7*5 Part 2: Working Days in the First Partial Weekīy default Tableau counts Saturday as the 7th day of the week and we want to count backwards how many working days have led up to it from our start date in our first partial week. We divide this by 7 and multiply it by 5 to get the number of working days in these weeks. Naomi Novik’s stunning series of novels follow the adventures of Captain William Laurence and his fighting dragon, Temeraire, as they are thrown together to fight for Britain during the turbulent time of the Napoleonic Wars. ![]() Now we have a number that is a multiple of 7 and will reflect the number of days in the full weeks between the start and end date. Then we trim off the days in the partial week at the end of the time frame to take us back to end of the last full week. ![]() Subtracting 7 minus the weekday number takes us upto the end of the first Sunday. Then we trim off days in the first partial week of the time frame. ![]()
0 Comments
Leave a Reply. |