Woz
Tera Contributor

Percentages in Performance Analytics

 I am often asked how to work out percentages in PA so here is super short and to point article that discusses the basics.

 

Percentages of a total

Example: How many Incidents created last month were closed within SLA

If we wanted to know how many incidents created last month were closed within SLA we would need to know two things

  • How many incidents were closed last month (Total Denominator)
  • How many incidents were closed within SLA (Percentage of total we want or Numerator)

To get our percentage we then do the following calculation:

(percentage of total we want / total) * 100

Or

 find_real_file.png

Percentage remaining

Example: How many Incidents were “Right first Time”

 

Sometimes we may not have an indicator to that holds the dataset we need left but we do have one that holds the reverse or we may simple want to work the percentage.

Let’s imagine we have an indicator that counts the number of Incidents that have been re-opened and we want to know how many incidents were right first time

We are interested in only closed incidents so “total number of closed incidents” will be our Denominator. For the Numerator we simply subtract the “incidents that have been reopened” from the “total number of closed incidents” which leaves us with total number of incidents that have not been reopened.

We can then divide our numerator by our denominator  and * 100

 

 find_real_file.png

Comments
Waldo Lavaut1
Tera Contributor

This article is helpful but incomplete. Providing screenshots on how to create those indicators, indicator sources, and the job associated would make this a badass article! Would it be possible to get an update?

DJL2
Kilo Guru

Hi Waldo,

This post isn't incomplete.  It is purposed to describe the technique and approach within 'Formula Indicators' for calculating a percentage, using Automated Indicators.

What you are describing is the essential, foundation knowledge for developing within PA and extensive guidance on that is already well described and advertised.

Learning the basics of PA is always the best place to start.  It'll give you the foundation and understanding to build from.

Thanks,

DJL

Waldo Lavaut1
Tera Contributor

Do you mind sharing a link to a guide/post/article on how to get Incident SLA % (percentage) Met vs breached, month over month? 

I have attempt to build a formula indicator using some automated indicators to obtain percentages, but when I add those indicators to a job collector and run it, it always collects the data with Warnings or Errors, and then the widget using the formula indicator built for % (percentages) doesn't show what I need to see. 

I can't find anywhere a complete article showing step by step on how to do something at least similar and I'm very frustrated. So I'm questioning at this point what I think I have learned about PA.

Version history
Last update:
‎02-04-2021 09:18 AM
Updated by: