Hey gang! I'm putting together a report that is tracking the percentage of abandoned calls (people hanging up before call center rep gets to the call). Currently, my formula is thus:

1-Activity.isdc_inbound_call_answered__c:SUM/RowCount

Essentially, I've got a field called "Call Answered" that I'm summing up then dividing by the total number of calls. I subtract the whole bag from one and I get my abandonment percentage. All is well.

The problem arose when the powers that be told me they only want to include calls with a "Wait Time" (another field) over 30 sec. I have searched site after site, post after post and cannot find the solution to this. It boils down to this statement => "Add up all unanswered calls with a wait time of over 30 seconds, divide by the total number of calls, then subtract from one". Make sense? Good.

Please help pull me out of this interwebs rabbit hole. Thanks in advance!

Hi Friends,

Does anyone have sample test class for apex class which has soql query for External Objects? Kindly share.

Thanks,
Loges