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

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

  • May 24, 2018
  • 2 replies
  • 227 views

Abdul
QPN Level 1 ●
Forum|alt.badge.img+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

Best answer by PeeyushBansal

first convert it in to one unit say Minutes

2 replies

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+44
  • Level 6 ●●●●●●
  • May 24, 2018
you have to set this as number set to have average

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+44
  • Level 6 ●●●●●●
  • Answer
  • May 24, 2018
first convert it in to one unit say Minutes