1 Reply Latest reply on Sep 13, 2018 8:56 AM by Shinichiro Murakami

    Removing zero counts across multiple columns / measure values

    Joseph Kulasa

      I am trying to measure number of defects across multiple columns, but I only want values greater than 0 to display. I can't currently create a calculated field on a measure value pill, nor can I sort out counts using the filter.  My data is set up to measure counts of defect type sorted by columns.  For instance, row 1 column 3 in the screenshot (shown as "Ca") lists 8 camber rejects.  One important note: there are over 75 different defect columns, so calculating all would be extremely difficult.

       

      I am in need of the following:

       

      • Only values greater than 0 to display
      • When 1 lot has a value > than 0, I need the others to be blank

       

      Thanks