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

# 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])

• ###### Re: Count only open high priority tickets

Hi,

Try this,

=Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])

Hope it helps

• ###### Re: Count only open high priority tickets

Will this work?

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

• ###### Re: Count only open high priority tickets

Sorry Alex it doesnt work

• ###### Re: Count only open high priority tickets

then it is better using set analysis?

=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])

• ###### Re: Count only open high priority tickets

HI,

Did u try this..

=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},Request Status]={ 'Closed'} Distinct[Case Id])

• ###### Re: Count only open high priority tickets

yes but it does work ;-(

• ###### Re: Count only open high priority tickets

Sorry it doesnt work.

• ###### Re: Count only open high priority tickets

When you said it is not working, does that mean the number was not right? or it is not doing what you want?

Maybe you just try to see if Count({<Priority= {'High'}>} Distinct[Case Id]) can get u a right number?

• ###### Re: Count only open high priority tickets

Count({<Priority= {'High'},[Request Status]= - {'Closed'}>} Distinct[Case Id])

• ###### Re: Count only open high priority tickets

After multiple attemps the formula below works.

=Num(Count({1<[Request Status]={'Assigned'}>}[Case Id]),'#,##0') +Num(Count({1<[Request Status]={'Pending'}>}[Case Id]),'#,##0')+ Num(Count({1<[Request Status]={'Unassigned'}>}[Case Id]),'#,##0')+Num(Count({1<[Request Status]={'Sent to ITServus'}>}[Case Id]

),'#,##0')