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')