This content has been marked as final. Show 3 replies
I believe this formula INT((DAY([wrkld_dt])-1)/7)+1 in a calculated field should give you what you are looking for.
Thanks Shawn, that worked great.
It would be cleaner if Tableau would offer a couple additional functions:
- Div function - They have Mod, but no Div (or in Excel Quotient)
- Floor function - I had to use INT to accomplish it (but that does not read as clearly)
- Ceiling function - If you have a floor you need a ceiling