4 Replies Latest reply on Jul 19, 2018 9:08 AM by Donna Hise

    Calculated field for last date of change to field

    Donna Hise

      I have been wrestling with something on and off for a couple of days, with no success.

       

      In my data, each revision to an order has a Date Processed and a Stage.  Orders can move back and forth between stages.  I want to have my view show each order only once, showing data for the latest revision.  However, I want create a calculated field to show the LAST date the Stage changed from "Stage 1" to "Stage 2" (this may or may not be the same date as the Max of Date Processed).  I also need to be able to filter by the calculated field.

       

      I am running Tableau Desktop 10.1.3 and publishing to Tableau Server 10.1.3.  A sample workbook is attached.  Any help would be greatly appreciated.