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
Page 1 / 1
you have to set this as number set to have average
first convert it in to one unit say Minutes
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.