Hello,

I hope someone can help me decipher the formatting of the average time values in the CSV Exports in the Performance views.

When viewing on PureCloud, they appear in a XmXs format, like so:


But when exported to CSV, this is what I can see:


How does one get from  364804.399402804 to 6m 5s?

Thank you in advance,
#Reporting/Analytics

------------------------------
Elka Czarny
HelloFresh
------------------------------

Hi Elka,

I think that might be milliseconds.

6m 5s = 365 seconds.
365 seconds = 365,000 milliseconds

As far as I know the reports will round decimals up.

You're real time 364804 milliseconds.
364804 milliseconds = 364.8 seconds, rounded up to 365.

Hope that helps.

------------------------------
Craig Stevenson
https://www.linkedin.com/in/craig-stevenson-contact-centre-cx-specialist-b5249996/

QPC UK
https://www.linkedin.com/company/qpc/
------------------------------

Original Message:
Sent: 05-16-2019 04:33
From: Elka Czarny
Subject: CSV Export of Performance Views - time value formatting

Hello,

I hope someone can help me decipher the formatting of the average time values in the CSV Exports in the Performance views.

When viewing on PureCloud, they appear in a XmXs format, like so:


But when exported to CSV, this is what I can see:


How does one get from  364804.399402804 to 6m 5s?

Thank you in advance,
#Reporting/Analytics

------------------------------
Elka Czarny
HelloFresh
------------------------------

Hey Craig!

Thanks for your help!

I also found this post from last year, a little too late: https://community.genesys.com/communities/community-home/digestviewer/viewthread?GroupId=19&MessageKey=c9d4f41d-5853-4bc6-88fa-9428ff69a19c&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dbab95e9c-6bbe-4a13-8ade-8ec0faf733d4%26tab%3ddigestviewer

Thanks again,
Elka

------------------------------
Elka Czarny
HelloFresh
------------------------------

Original Message:
Sent: 05-16-2019 08:49
From: Craig Stevenson
Subject: CSV Export of Performance Views - time value formatting

Hi Elka,

I think that might be milliseconds.

6m 5s = 365 seconds.
365 seconds = 365,000 milliseconds

As far as I know the reports will round decimals up.

You're real time 364804 milliseconds.
364804 milliseconds = 364.8 seconds, rounded up to 365.

Hope that helps.

------------------------------
Craig Stevenson
https://www.linkedin.com/in/craig-stevenson-contact-centre-cx-specialist-b5249996/

QPC UK
https://www.linkedin.com/company/qpc/

Original Message:
Sent: 05-16-2019 04:33
From: Elka Czarny
Subject: CSV Export of Performance Views - time value formatting

Hello,

I hope someone can help me decipher the formatting of the average time values in the CSV Exports in the Performance views.

When viewing on PureCloud, they appear in a XmXs format, like so:


But when exported to CSV, this is what I can see:


How does one get from  364804.399402804 to 6m 5s?

Thank you in advance,
#Reporting/Analytics

------------------------------
Elka Czarny
HelloFresh
------------------------------

Welcome :-)


------------------------------
Craig Stevenson
https://www.linkedin.com/in/craig-stevenson-contact-centre-cx-specialist-b5249996/

QPC UK
https://www.linkedin.com/company/qpc/
------------------------------

Original Message:
Sent: 05-16-2019 08:57
From: Elka Czarny
Subject: CSV Export of Performance Views - time value formatting

Hey Craig!

Thanks for your help!

I also found this post from last year, a little too late: https://community.genesys.com/communities/community-home/digestviewer/viewthread?GroupId=19&MessageKey=c9d4f41d-5853-4bc6-88fa-9428ff69a19c&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dbab95e9c-6bbe-4a13-8ade-8ec0faf733d4%26tab%3ddigestviewer

Thanks again,
Elka

------------------------------
Elka Czarny
HelloFresh

Original Message:
Sent: 05-16-2019 08:49
From: Craig Stevenson
Subject: CSV Export of Performance Views - time value formatting

Hi Elka,

I think that might be milliseconds.

6m 5s = 365 seconds.
365 seconds = 365,000 milliseconds

As far as I know the reports will round decimals up.

You're real time 364804 milliseconds.
364804 milliseconds = 364.8 seconds, rounded up to 365.

Hope that helps.

------------------------------
Craig Stevenson
https://www.linkedin.com/in/craig-stevenson-contact-centre-cx-specialist-b5249996/

QPC UK
https://www.linkedin.com/company/qpc/

Original Message:
Sent: 05-16-2019 04:33
From: Elka Czarny
Subject: CSV Export of Performance Views - time value formatting

Hello,

I hope someone can help me decipher the formatting of the average time values in the CSV Exports in the Performance views.

When viewing on PureCloud, they appear in a XmXs format, like so:


But when exported to CSV, this is what I can see:


How does one get from  364804.399402804 to 6m 5s?

Thank you in advance,
#Reporting/Analytics

------------------------------
Elka Czarny
HelloFresh
------------------------------