Hello,

I have a table that contains all of our call data including call length in seconds. I've used the sec_to_time function to convert the seconds to HH:MM:SS format within the table but I would like to be able to aggregate call length and display in the HH:MM:SS format in a dashboard widget. The goal is to show agent performance (leads, deals, conversation ratio, number of calls and how long they've spent on the phone) in a widget for each metric/KPI.

I've got everything working that I need other than the ability to roll up call length per agent over a given period of time (controlled by a user date filter on the dashboard). Does anyone know how to do this? I've also tried different options with a picot report but can't get things to roll up based on date filtering.

Thanks

Shane