1 Reply Latest reply on Jun 9, 2016 4:03 PM by Ivan Young

    aggregate based on a measure

    Thai Huynh

      I have a simple situation but I can't seem to figure out.

      Here is a simplified version of data I have: 10 parts and associated number of defects.

      I need to count how many parts with at least one defect (3) and a count of how many parts WITHOUT defect (7).

      Ultimately I need to find  the percentage, that is, 3/10 = 30%

      Thanks!

       

      PartIDDefect
      A0
      B0
      C1
      D2
      E1
      F0
      G0
      H0
      I0
      J0

                                                

      PARTDEFECT
      A0
      B0
      C0
      D0
      E1
      F2
      G0
      H4
      I0
      J0