Tasks involved are:- 
a) Record the count of chats when uploading tickets by excel sheet by referring the group name with “Chatâ€. 
b) Display the count of chats on the dashboard module, all cronjob email/backend reports and iterate the count of chat/tickets in the “Tickets Reportâ€ page for each team.
c) Display the purpose of each field for future reference on the column mapping page. 
