microsoft / microsoft/CopilotChatAnalytics

Analytics in Excel is missing data

Open
#10 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
No language data
Stars
21
Forks
4
PR merge metrics
No merged PRs in 30d

Description

Hello,

I noticed that when downloading the sessions of the virtual agent on Copilot Studio under Analytics, the exported file in Excel in csv format is deleting the data after formatting.

Without formatting it is not possible to read the data, so in order to get the data under the correct column it needs to be formatted, which results in cancellation of half of the data, which are the chattrasncript and session outcome.

Any idea on the issue?

Regards,
Tina

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the Analytics session export from Copilot Studio and compare the CSV before and after opening or formatting it in Excel. The issue does not name a repository file or test, so locate the export path and identify where chat transcript and session outcome data are lost. Done means the formatted export retains those fields in the correct columns.

Written by the indexing model from the issue text.

Assessment

Domain
analytics
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.