I am trying to visualize the current weekly FYTD vs prior weekly FYTD and the fiscal year for my visualization starts from July 1st of the year. But July 1 2017 is Saturday i.e.
1st week of prior weekly FYTD is 25 th june 2017 to 1st July 2017 and
1st week of current weekly FYTD is i 1st July 2017 to 7 th July 2017. How to change the 1st week of prior weekly FYTD to show 2nd July 2017 to 8 th July 2017.
Thanks in advance
Used Table calculations to get to this solution.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...