12 Replies Latest reply on Dec 13, 2017 3:48 AM by DHEERAJ ARORA

    Find Active Items between Start and End Date

    DHEERAJ ARORA

      I am facing a challange in tableau to create a line chart which shows last 13 month trending.

       

      I want every PRSN_INIT_ID should be spread month over month with the range of EFBEG_DT and EFEND_DT

      So that I can make the trend chart to show how much employees contributing(Contribution Rate) month over month.

      I wants to make this in tableau but unable to so so please help me to solve this.

       

      I found many links on tableau community but those were not fulfill my requirement. I want the data should come in order to the below given Expected Result section.

       

      Here is the data:

      PRSN_INTN_IDEFBEG_DTEFEND_DTContribution_RateEMPL_STAT_CD
      A011110/25/20156/30/20164ACTIVE
      A022212/1/20162/28/20173ACTIVE
      A03331/1/20174/1/20170ACTIVE

      Minimum Date: 10/25/2015

      Maximum Date: 4/1/2017

       

      Expected Result:

         

      MonthActive EmployeeEmployee Who Active
      15-Oct1A0111
      15-Nov1A0111
      15-Dec1A0111
      16-Jan1A0111
      16-Feb1A0111
      16-Mar1A0111
      16-Apr1A0111
      16-May1A0111
      16-Jun1A0111
      16-Jul
      16-Aug
      16-Sep
      16-Oct
      16-Nov
      16-Dec1A0222
      17-Jan2A0222, A0333
      17-Feb2A0222, A0333
      17-Mar1A0333
      17-Apr1A0333