Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Dec 28, 2018, 4:07 AM

Select any block of weekdays throughout the year

Suppose that I have a date parameter named Start Date and another date parameter named End Date. If I set Start Date to '2018-12-21' and set End Date to '2018-12-24', I want the filter to retain not just 2018-12-21 to 2018-12-24 (i.e. Friday to Monday), but also all the Friday-Monday blocks that happen before. The specific outcome of the filter is as follows

 

Day of YmdWeekday of YmdTrue/ False12/14/2018FridayTRUE12/15/2018SaturdayTRUE12/16/2018SundayTRUE12/17/2018MondayTRUE12/18/2018TuesdayFALSE12/19/2018WednesdayFALSE12/20/2018ThursdayFALSE12/21/2018FridayTRUE12/22/2018SaturdayTRUE12/23/2018SundayTRUE12/24/2018MondayTRUE12/25/2018TuesdayFALSE12/26/2018WednesdayFALSE12/27/2018ThursdayFALSE

 

If  I change the End Date to 2018-12-25, then the following outcome will result:

 

Day of YmdWeekday of YmdTrue/ False12/14/2018FridayTRUE12/15/2018SaturdayTRUE12/16/2018SundayTRUE12/17/2018MondayTRUE12/18/2018TuesdayTRUE12/19/2018WednesdayFALSE12/20/2018ThursdayFALSE12/21/2018FridayTRUE12/22/2018SaturdayTRUE12/23/2018SundayTRUE12/24/2018MondayTRUE12/25/2018TuesdayTRUE12/26/2018WednesdayFALSE12/27/2018ThursdayFALSE

 

Is there a way to achieve this? Brute force method is also welcome.

10 answers
  1. Deepak Rai
    Dec 28, 2018, 7:32 AM

    Here it is: Create this Calc and Take out FALSE in Filter.

    Here it is: Create this Calc and Take out FALSE in Filter.

    Thanks

    Deepak

    If it Helps, Pl mark it Helpful and CORRECT to Close Thread

Write an answer...
0/9000