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

    Calculated Number of Days passed with Pivoted Fields?

    Zack douglas

      Hello,

       

      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')) 

       

      Thanks