4 Replies Latest reply on Aug 6, 2018 9:57 PM by meenu choudhary

    How to get the dimension value which is present in one date range but not in another

    Kapil Lehar

      Hi Everyone,

       

      I have a requirement in Tableau where in if the customer name is present in the set of (current month – 1) based on date, does not exist in the set of (current month – 4 to current month – 2), then that customer is added to the new customer database, flagged as added in (current month – 1).

      Please find the below table as an example where in i need the "ght" customer name.

       

      Edit 1 : Basically we are trying to load those customers which are present in the latest month -1. If yes then  load those new customers to a group or use a flag to mark the new or old.

       

      Thanks in advance....

      MonthCustomerCurrent Month-1Current Month-2 to -4
      Febabcabc
      Mardefdef
      Aprxyzxyz
      Maycfgcfg
      Junlmnlmn
      Julghtght
      Julxyzxyz
      Augyut