3 Replies Latest reply on Oct 4, 2018 6:17 PM by Chinnala J

    Compare with previous month data and show only records in current month that match certain criteria

    Chinnala J

      Hi Tableau friends,

      I am trying to put together a logic to look at data from previous month (i.e. september month in attached workbook) that are not of operation type 'Delete' and get current month (october month) records that are with operation 'Delete'. I am able to get all the records but struggling to put a logic to just show only october month records that are of operation type Delete in current month for that Id AND are having operation type not as delete in previous month

       

      Raw Data:

       

      IdOperationMonth
      1Add2-Sep
      2Add3-Sep
      3Update4-Sep
      4Delete5-Sep
      5Update6-Sep
      1Delete7-Oct
      2Update8-Oct
      3Delete9-Oct
      4Delete10-Oct
      6Add11-Oct

       

       

      Expected Output

       

      IdOperationMonth
      1Delete7-Oct
      3Delete9-Oct

       

      Please assist