7 Replies Latest reply on Mar 10, 2017 5:38 AM by Shinichiro Murakami

    Not able to find duplicate within the first month

    arvind jain

      Hi All,

       

      I am using the below formula for finding the duplicate. this is working perfect when first month is not having duplicate value

      IF [Month] = 1 THEN { FIXED [Name],[Month] : COUNT([Name])}

      ELSEIF [Month] = 2 THEN {FIXED [Name]:COUNT( if [Month]>=1 AND [Month]<=2 THEN [Name] END)}

      ELSEIF  [Month] = 3 THEN { FIXED [Name] : COUNT([Name])}

      END

       

      However I am facing issue when first month is having duplicate value.

       

      Please find the attached data file and tableau file,

      For the first month I should get like below however I am getting 2 as a value in tableau using the formula in sheet1.

         

      1/1/20161CAL00051-3rd Carrier-RF Tuning (Drive-Based): SSV/Cluster Analysis & Recommendation-Single Site Verification (SSV)1
      1/1/20161CAL00051-3rd Carrier-RF Tuning (Drive-Based): SSV/Cluster Analysis & Recommendation-Single Site Verification (SSV)2

       

      For 1st month I should get FTR as 8 not 7 in sheet2.

      sheet2.png

      Please help me here