How to find number of Chats completed every day and hour in Salesforce using report?


1. Create a Custom Report type for Chat Transcripts object.

 
2. Create a report using the report type created from the step1.

3. Create a formula field in the Report to find the hour of Chat Transcript End Time.
 
Formula:
LEFT( RIGHT( TEXT( LiveChatTranscript.EndTime - ( 4/24 ) ), 9 ), 2 ) 

Note:
I have used GMT-4 for the hour calculation. You can adjust it as required.
Reference Link:


Output:
 
 

Video Reference:

Number of Chats completed every day... x
Number of Chats completed every day and hour in Salesforce using report