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.