4 Replies Latest reply on Dec 7, 2017 12:03 PM by Michael Feigin

    Filtering on a given field to include all data meeting criteria

    Michael Feigin

      Hello, I have a table with WORK TYPE messages processed by hour.

      I want to display only those hours when the count of BPM-856 was over 2,500 per hour. The thing is that I need to show all WORK TYPEs.

       

      Obviously, the filter I created (BPM-856 Filter in my workbook) does not do what I want it to do:

      IF [Work Type] <>"BPM-856"

      THEN "Doesn't Meet Criteria"

      ELSEIF [Count]>2500

      THEN "Meets Criteria"

      ELSE "Doesn't Meet Criteria"

      END

       

      I suspect it's a pretty simple solution, but it escapes me. Can you please help me?

       

      Thanks.