11 Replies Latest reply on Oct 4, 2013 12:25 PM by Brunella B.

    Static parameter of date

    Brunella B.

      Hi

      I'm working on Tableau public, Excel data; it's impossible leave a static date because I can't compare with other rows

      I have a calculated fied with a date

      Example:

      I need compare a Row and a column with others rows about the same column and I can't because only compare that date with the same. Tableau saves the value of dimension accompanied with the row

       

      [Date C.Actual] = calculated field, for example the MAX value. Only 1 result

      [Date# Closed Actual] = Excel column

       

      DATEDIFF('year',[Date C.Actual],[Date# Closed Actual] )

       

      the result will be: only rows that have the field coincided with [Date C.Actual]  the same row

       

      I can't change the format of date

      it's difficult to explain it

       

       

      thanks in advance