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.760 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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,314)