Compare values using different expressions- Vlookup

Content

 

We have two different tables that we need to include within the same report.

Table 1 = Incidents. Total incidents logged by Agent

Table 2= Calls. Total calls received by agent.

The aim is to compare and then give a pass or a fail depending on if the agent logged all of the calls received.

 

The table 2 data comes through our telephony provider via an add in.

Unfortunately the Agent names are slightly different through the telephony provider so you cannot compare the incident,created_by (Servicecloud)  against the $CallStatus.UserName. (telephony add in)

As a work around I added a variable which changes the agent names (for the telephony add in) to match that of the incident.created-by