11 Replies Latest reply on May 17, 2018 11:16 AM by zack.douglas

    Calculated Number of Days passed with Pivoted Fields?




      In my data source I had four dates that I turned into pivoted fields to create a status tracker in tableau. One of the fields were called 'Open Date'. I am trying to calculate the number of days passed since the 'Open Date' but I need help creating the calculated field.


      I am using the formula below but it won't single out the "Open Date' portion of the pivoted field. Any ideas?


      ATTR(DATEDIFF('day',[Pivot Field Names]='Open Date',TODAY(),'sunday'))