Last Modified Date: 22 May 2020
Environment
- Tableau Desktop
Answer
Create a calculated field named as Start Day - End Day of Week which contains the following calculation.
STR(MONTH(DATETRUNC('week',[Order Date])))+"/"+
STR(DAY(DATETRUNC('week',[Order Date])))
+ " - " +
STR(MONTH(DATETRUNC('week',DATEADD('week',1,[Order Date]))-1))+"/"+
STR(DAY(DATETRUNC('week',DATEADD('week',1,[Order Date]))-1))
The above calculation is demonstrated in the attached workbook.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials