You will need to set up the 'Ticket Activities report' from Reports--> Scheduled Export--> Daily export of ticket activities and have the data stored in a BI tool. To know more about this feature you can refer this link