7 Replies Latest reply on Apr 12, 2017 9:20 PM by Okechukwu Ossai

    Is it possible to compare previous week value (string) with current week value (string) and flag them with 1 if not equal?


      Hello Tableau Community,


      I am facing a problem as I am trying to set up an automatic dashboard in Tableau for a weekly meeting. I would like to flag each ID & name combination with a 1 if the previous week value is not equal to the current week value. Please see screenshot below. We are looking at the Updates field. For example, for Cedric, it should be flagged as 1 as the last week update is different from the current week update.


      I would love to make it dynamic based on the date parameter I have created called Select date.

      I am currently using Tableau 10.1. Attached also is the workbook.