Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to calculate Responses Sent by Agent / Total Login time by Agent in one report

edited May 11, 2016 4:26PM in Reporting & Analytics for B2C Service 4 comments

Content

Request

  • Calculate PPHW using the following formula
    • PPHW = Responses sent by Agent/Total Login Time By Agent

Issue

I'm unable to get this data on one report because Responses sent by Agent is using the 'Transaction's table and Agent Total Login Time is captured in the 'User Trans' table. It won't allow me to join these two tables to get the data in one report. Any ideas on how I can achieve this?

 

Thank you

Ajay John

 

Version

Feb 2014
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!