Showing results for 
Search instead for 
Did you mean: 
New Member

How are the numbers calculated?



I'm fairly new to Bot analytics. Our company has just create a new Chatbot on Teams and I've been asked how the percentages are calculated? For example the resolution rate graph is heading up but the percentage is down by 7%.



Another example.... Escalation rate chart is going down but the percentage has a up red arrow?




I'd be eternally grateful to anyone who is able to point me in the right direction on how the numbers are derived.


Thank you,


Super User
Super User

Hi @YinOnn ,


Microsoft has provided a solution to export these dashboards and customize them within the Power BI.

Take a look at the documentation below, I think that you can see the calculation formulas, and let us know if you need anything else.

Custom Analytics solution for Power Virtual Agents | Microsoft Power Virtual Agents 

Did I answer your question? Mark my post as a solution!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português
New Member

Hi @renatoromao,


Thanks for your speedy response.


Had a look at the video in your link and found it extremely useful. Tried using it on PVA on Teams but it looked very different.  I'm unable to create a PowerBI Dataflow to my Instance but I was able to connect using PowerBI only to find that the conversationtrnscripts table is empty. However, I did manage to locate my bots in the bots table.


So close yet no cigar. Could creating the chatbot on PVA on Teams be the issue? Perhaps all these data is not made available on PVA on Teams?




Helpful resources

PVA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Users online (1,881)