Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Aaron Liu
    Custom report data display is wrong
    Topic posted December 17, 2018 by Aaron Liu 
    16 Views, 2 Comments
    Title:
    Custom report data display is wrong
    Content:

    Dear all

    When using the RN system, we need to record the status of the agent login every day, such as the number of logins, the number of logouts, the login duration, the chat duration, and so on. So I made a custom report (100247) based on the tables chat_agent_sessions and chat_agent_intervals, see Annex 1.


    However, the number of logins and the number of logouts counted by the report (100276) are different from the reports (100280) according to the table chat_agent_sessions, refer to Annex 2. 


    Can you help me solve this problem?

    Attachment is the definition of two reports

    Thanks

    Image:
    Document:
    100247.xml (32KB)
    Document:
    100280.xml (15KB)

    Comment

     

    • Aaron Liu
    • Luuk

      What I usually do in these kind of situations is remove columns one by one until the two reports match.
      Just remove -> run -> remove -> run untill the report works.
      If the report matches the original, you'll notice that this column breaks the report.