How to show average time in a panel

How to show average time in a panel

Hello,

We currently have a requirement to build a label in a dashboard that shows the average wait time for a clinic. Our data is stored in Seconds (integer), so what we need is to calculate this column's average and show it in a formatted way (HH:mm:ss) inside a panel, simply as a label.

How can we achieve that?