10 Replies Latest reply: Jul 16, 2012 1:25 PM by jafreisy Nunez RSS

    Count only open high priority tickets

      I'm using the below formula on a chart. I'm trying to count a total of cases with high priority which current status is not closed. HELP!!!!

       

      =Count(Priority= 'High' and [Request Status]= 'Closed', Distinct[Case Id])