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

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

  • 24 May 2018
  • 2 replies
  • 138 views

Userlevel 1
Badge +4
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
icon

Best answer by PeeyushBansal 24 May 2018, 07:36

View original

2 replies

Userlevel 7
Badge +33
you have to set this as number set to have average
Userlevel 7
Badge +33
first convert it in to one unit say Minutes

Leave a Reply