Format Call Detail Records (CDR) for Europe Format in Analytics for 8x8 Work

Format Call Detail Records (CDR) for Europe Format in Analytics for 8x8 Work

Objective

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

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 Excel spreadsheet.
  7. Select the top of the column with the Date data you want to change.

  1. Copy this data.
  2. Open a new tab.

  1. Paste the Data in the first column (A).

  1. Highlight Column A.
  2. Select Data and then Text to Columns. This opens a new window.

  1. Select Delimited and then Next.

  1. Under Delimiters only select Space and then Next.

  1. 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.)
  2. Select Finish.

  1. Here you can see the old and new data formats.

  1. Select the top of column A.
  2. Copy this data.
  3. Open the original tab.

  1. Select the top of the column with the Date data you what to change.
  2. Paste the new data.