Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I know this is a simple thing to do, but how do I alter the expression below to ignore any selections made by the "IM Missed SLA" filter?
=count(DISTINCT{<[IM Missed SLA]={'No'},[IM Resolved Flag]={1},[Date Type ID]={2}>}[Ticket ID])/
count(DISTINCT {<[IM Resolved Flag]={1},[Date Type ID]={2}>}[Ticket ID])
May be this:
=Count(DISTINCT{<[IM Missed SLA] = {'No'}, [IM Resolved Flag] = {1}, [Date Type ID] = {2}>} [Ticket ID])/
Count(DISTINCT {<[IM Missed SLA], [IM Resolved Flag] = {1}, [Date Type ID] = {2}>} [Ticket ID])
Thanks Sunny! That works perfectly!
Awesome