Report Query?

1__RyanJSadler
Tera Contributor

I am trying to run a report where I would like to see the following interaction data:

 

Chats

Inbound Calls

Outbound Calls

 

I can run a simple report to gather all calls and chats using the following filter:

 

State: Completed

Opened: Yesterdays

type:  chat or phone

 

I have tried adding additional data sets, and adding related condition, but as soon as I do that it creates duplicate fields with no data (and I cant seem to see a way to remove these).

 

Screenshot 2024-03-27 143555.png

 

Screenshot 2024-03-27 144046.png

 

Screenshot 2024-03-27 143511.png

What I would like to be able to do, is break down the phone interaction to show inbound and outbound all in the same bar graph.

Any idea if this type of report is achievable?

 

Thanks

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Could you please share teh 2nd screenshot again I am not able to see it properly. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

 

Hi @1__RyanJSadler 

 

I tried at my end but did not find Phone Log as related list in my table drop down

 

AGLearnNGrow_0-1711625346065.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hey Atul, please find attached the requested image.