Skip to main content

 

 
8x8 Support

Format Call Detail Records (CDR) for Europe Format

  1. Last updated
  2. Save as PDF

Objective

Format the date ranges from M/D/Y To D/M/Y in Analytics for 8x8 Work.

Applies To

  • Analytics for 8x8 Work

Procedure

  1. Log in to Analytics for 8x8 Work.
  2. From the left panel highlight Call Report, then select Call Detail Records.
     
  3. Set the time and date range required.
  4. Set the View to Call Legs simplified (If this is not selected then the report will not include calls that will pass through the ring group as it will only focus on the destination).
  5. Select Download.
  6. Open The downloaded document Microsoft Excel.
  7. Select the TOP of the column with the Date data you want to change.
    clipboard_e2d5ab9796ba7bd554eb654a018679448.png
  8. Copy this data.
  9. Open a new tab. 
    clipboard_ea92f59b91526aa955bd3a6bf41c55d7a.png
  10. Paste the Data in the first column (A).
    clipboard_e8000b4daf2f581b335163f03cb1b448e.png
  11. Highlight Column A.
  12. Select Data and then Text to Columns.
    clipboard_e29fd9aec300379d3b2875c6f34f2d60c.png
  13. This opens a new window select Delimited and then Next.
    clipboard_ef8ee5f97b86a13d0db8c58ab978c4f0a.png
  14. Under Delimiters only select Space and then Next.
    clipboard_e499a92cc88e8ae76e3679739f4387124.png
  15. Under Column Data Format only select Date and from the dropdown change from D/M/Y to M/D/Y (This is to get it to swap what it currently thinks is D/M/Y)  then select Finish.
    clipboard_e1db468ce0a47383dfd6ff0528eb3f8c4.png
  16. Here you can see the OLD and NEW data format.
    clipboard_ee46907da36196636850af489a6fcfe93.png
  17. Select the TOP of column A.
  18. Copy this data.
  19. Open the Original Tab.
    clipboard_e9539334125d0cb5d0e66b31468d94e95.png
  20. Select the TOP of the column with the Date data you what to change.
  21. Paste the new data.
    clipboard_e00b1d39cee2a21fa213fb6017b1fd9f6.png