3 Replies Latest reply on Nov 7, 2018 4:45 PM by Zhouyi Zhang

    Comparing Data

    Albert Kurniawan

      Hi,

       

      I want to make comparison with condition :

      if a traffic from the same date of last year is 0 then the traffic of the same date current year must be set to 0

      or if the traffic current year = 0 but the traffic of last year not equal 0, then it must be set to 0.

       

       

      From the sample data below, The Total traffic which I want for 2018 = 12 and Total traffic for 2017 = 11.

      How to make a filter to compare the same date in tableau ? Please anyone help me to solve this problem.

       

      Thank

       

      Untitled1.png