2 Replies Latest reply on Jan 31, 2019 1:13 PM by Apurva Sherke

    Funnel Chart: Table Calculation issue in Tableau

    Apurva  Sherke

      Hello All,

       

      I have an issue with calculation in tableau.

      I have two columns Stage 1 and Stage 2 and I have calculated those fields in SQL. I have Opportunity column in my data which has duplicate entries. Please find the attached image.

      Which calculations should I use to get the results as shown in the image?

       

      IMG_2926.jpg

       

      We have duplicate entries for opportunity like for A we have 4 rows and for B we have 4 rows. I want to count opportunity A as 1 not 4 and since B has -ve values in stage1 and stage2, it should not be counted. How can I do this in Tableau?

       

      I have a deadline to finish this off. I will really appreciate your help on this. Thanks in Advance

       

      Regards,

      Apurv