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
Jul 11, 2018, 3:11 AM

Display all the weeks between two dates

Hello Everyone,

 

I have project start date and project end date, like this.

Proj Number          Proj Start date                 Proj End Date

123                         17-05-2018                     08-10-2018

1234                       21-02-2018                     04-12-2018

 

Here i want to display the weeks between these two dates

eg.,  for 1st project , week 20 to week 41. So i should display all week 20  week 21  week 22 week 23 till week 41 or either i should display the dates(like week starting date)

so that i want to track down all the employees/projects falls in between these weeks

I tried many ways but didn't get any way to get this weeks or dates like this.

 

Any idea please let me know.

2 answers
  1. Mahfooj Khan (Beinex Consluting)
    Jul 11, 2018, 5:56 AM

    Hi,

     

    Is there any provision to transform the structure of the data source?

    If yes then find my approach below,

     

    First you need to transpose the date fields into rows like this

    Hi, Is there any provision to transform the structure of the data source?

    Once done then drag the fields like this and show missing values from properties of the date field.

    pastedImage_6.png

    Finally change the DATEPART of the date field to get the week number

    pastedImage_7.png

    Here you go,

     

    pastedImage_5.png

     

    Let us know if this help.

     

    Mahfooj

Write an answer...
0/9000