6 Replies Latest reply on Feb 2, 2015 7:13 AM by Dan Zehner

    Data values change by date

    Dan Zehner

      Hello! I'm new to Tableau and I'm having trouble wrapping my head around how to calculate a specific value for a piece of data based on the date. Here's what I'm trying to do:

       

      Inputs

      Issue IDDPUClose DateResidual
      1234560.53/1/150.3


      I'm trying to make a table in Tableau that shows the DPU as 0.5 for all dates before the Close Date, and the Residual Value of 0.3 after the Close date. How do I relate this in a calculated field? I have 100,000+ lines of data that need this calculated, so it will have to do the calculation from my raw data.