Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently using this expression to count answered calls less than 30 sec per ID conversation and it's working nicely.
Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])
However, when I filter it by date, the numbers reflected on the totals is incorrect.
e.g. BEFORE FILTER: Oct 19 calls = 8 below 30 sec, 2 above threshold
AFTER FILTER: showing just Oct 19 data, calls = 10 below 30 sec.
Would appreciate your insights to this. Thanks!
what's your expected result after date selection ?
May be try this
Count(DISTINCT {<[Aggr tAnswered] = {"=Sum({<Date>}[Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])