4 Replies Latest reply on Mar 14, 2018 10:50 AM by Sowmya Potluri

    1 date column, shows both start n end date ... need rolling 12 month percent delta

    Sowmya Potluri

      Hi Tableau community,


      from back end table, data pulling 4 columns: LOB , Party Type, Date, Data


      in Tableau I need to produce LOB,Party Type,Start Date ,End Date, Data Difference (b//n Dates)


      i created Lookup CALC To pull previous date in another column as Start date...here the issue is it needs to pick based on LOB n Party type... how do i feed tableau this scenario.


      DATE(DATEADD('month',-11,DATETRUNC('month',[End Date]))) -Display for Start date.

      LOOKUP(ATTR([End Date]),-1) - Display for start date Data .... How do i feed tableau the index based on LOB and party type???



      Appreciate your help!!!