3 Replies Latest reply on Aug 7, 2018 8:03 PM by Shinichiro Murakami

    Finding when a dimension changes between user selected dates

    Tristan Smith

      Hi Tableau community. First time posting, but long time reader.

       

      I've been trying to figure out how to create a formula or series of formula's to determine when a dimension changes values between two dates.

       

      We have a dataset for our workforce and each fortnight the next series of data is appended to the data source. A simple example is attached.

       

      I would like the user to be able to select two dates and then the dashboard highlight what has changed within the workforce within that date range. In the attached example if the users want to see what's changed between 11/08/17 and 1/07/17, the dashboard should then just show two employees have changed their status; Maxwell moved from Temporary to Permanent status on 14/07/17 and Matthew moved from Temporary to Permanent on the 11/08/17.

       

      Any help would be appreciated.

       

      Cheers

       

      Tristan