Hi Community, I'm uploading Historic data...in which I've a Embedded field named as "Waiting_time" which records the time a customer was waiting until s/he was served by a customer care representative. The time is stored in the below format... 0:12:56 0:00:22 0:04:28 0:01:30 0:32:52 0:00:10 0:07:46 0:03:08 1:04:58 What should be the Field Type of this Embedded data field so that I can calculate the average wait time? Thanks, Abdul

first convert it in to one unit say Minutes

you have to set this as number set to have average

Can we find average of the time stamp and display in widget?

Can we find average of the time stamp and display in widget? | Experience Community