2 Replies Latest reply: Jan 29, 2018 10:50 AM by Sunny Talwar RSS

    Different data when filter is on

    Marj Pabilonia



      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

      Before filter.JPG


      AFTER FILTER: showing just Oct 19 data, calls = 10 below 30 sec.

      After Filter (date).JPG


      Would appreciate your insights to this. Thanks!