7 Replies Latest reply on Jun 9, 2017 7:30 AM by Rahul Upadhye

    Excluding the current incomplete week from Year over Year calculations

    Kevin White

      Hello,

       

      I'm trying to figure out a way to exclude the current incomplete week from my calculations. The data source I'm connected to is bringing the week # is as a string so all of the out of the box date calculations that Tableau comes with are not available to me. Essentially the problem is that if I'm creating a YOY calculation it automatically will include the current week even if its incomplete. I've tried creating a Set that only includes weeks in which we have sales for and then filtering on the Max week # but Tableau wont let me do that. I feel like there has to be a way to exclude that current week because im fairly close but just not all the way there.

       

       

      Any help would be greatly appreciated.