4 Replies Latest reply on Dec 19, 2016 10:47 AM by Christopher Antony

    count distinct based on a condition

    Christopher Antony

      HI guys,

       

      In the attached file , I am looking to have distinct count of names where the max hour violation is > 1, for each shift Could you please help  me with this?

       

      I tried using:

       

      COUNT (if [Max Hour Violations] > 1 then [Number of Records] END). but its not working.

       

      Thank you.