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

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,175)