Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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')
Hi,
Try this,
=Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])
Hope it helps
Will this work?
=Count(Priority= 'High' , Distinct[Case Id])-Count(Priority= 'High' and [Request Status]= 'Closed', Distinct[Case Id])
Sorry Alex it doesnt work
then it is better using set analysis?
=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])
HI,
Did u try this..
=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},Request Status]={ 'Closed'} Distinct[Case Id])
yes but it does work ;-(
Sorry it doesnt work.
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?
Count({<Priority= {'High'},[Request Status]= - {'Closed'}>} Distinct[Case Id])