Join chat_queue_stats with Incidents Table

Summary:

When I join Join chat_queue_stats with incidents table, it removes data and shows blank

I need to join the tables, becuase I need to know what agency the client belongs to. The Agency is located on the incident table when the client submits the chat.

When I add the agency column from the incidents table, the data shows blank.

Version (include the version you are using, if applicable):

25a

Code Snippet (add any code snippets that support your topic, if applicable):

SEE SCREEN SHOTS