Can I view the last activity time in Hotspot instead of just the last activity date? I want to analyze tickets based on the time of last activity, not just the date. Specifically, I would like to create reports, charts, or pivot tables that group tickets by hourly intervals. For example: • I will likely create a formula to calculate the difference between the current time and the last activity time. • The intervals should be grouped as follows: 2 hours, 3 hours, 4 hours, and so on, up to a maximum of 9 hours. • Any tickets older than 9 hours will be displayed in the 9-hour mark. This will help visually identify how many tickets are becoming older by the hour and ensure that responses happen as quickly as possible. Let me know if you need more details or clarification.
... Mehr anzeigen