3 Replies Latest reply on Jan 8, 2018 5:30 AM by suresh.gooty

    Missing Dates

    venkata siva prasad k

      Hi Guys,

       

      I have two fields contract start date and contract end date from ABC Data source

      I have one more filed Business Entry Date from XYZ Data source .

       

      My question is how can i get missed dates from both data sources

       

      contract start date    contract end date        Business Entry Date

      6/08/2017                 6/08/2018                      7/11/2017

                                                                             7/12/2017

                                                                             7/13/2017.

       

       

      above filed displaying like this in Tableau .

       

      I want to show below output in Tableau.

       

      contract start date    contract end date        Business Entry Date

      6/08/2017                 6/08/2018                      6/08/2017

                                                                             6/09/2017

                                                                             6/10/2017

                                                                                 ......

       

                                                                             7/11/2017

                                                                             7/12/2017.

       

       

      I want see the data from contract start date date in Business Entry Date.

       

      "Thanks in advance"

       

      Regard's,

      Prasad