Single score report with percentage using performance analytics
Before starting with the actual topic, let's have a look at a few of the basics: What is an Indicator Source? Indicator sources define sets of records from a ServiceNow table that have a common characteristic such as the Priority is critical or Task type in the incident. Indicator sources include filter conditions to limit the records. An indicator source can be considered as a tree with multiple branches and those branches are in the form of various indicators, automated indicators, etc. Conditions mentioned as part of an indicator source are automatically applied to the indicators and hence act as roots of the tree. What is an automated indicator? (From docs)Automated indicators save scores from an indicator source at a regular frequency such as daily, weekly, or monthly. An automated indicator can have its own conditions on top of the conditions mentioned in the indicator source. What is a formula indicator? Formula indicators use data from multiple other indicators to calculate metrics. Unlike automated indicators, formula indicators are not based on an indicator source that is populated during data collection. The score of a formula indicator is calculated from a mathematical statement that includes data from one or more other indicators. This data can be the score of an indicator as is explained in the attached video. In the attached video, a live example of a single score report is created based on the steps below: step 1: An indicator source is created on the task table so that it can be used across multiple other indicators. The condition given is the 'task type' as an incident. step 2: An automated indicator is created which filters all the breached incidents. step 3: An automated indicator is created which gives the count of all the incidents. step 4: Creation of data collection jobs for the automated indicators created above. step 5: A formula indicator is created with below condition [[indicator created in step 2]] / [[indicator created in step 3]] * 100 After saving the formula indicator, we can also check the score by clicking on the 'Show Scorecard' related link. step 6: Refer the formula indicator in a widget to display the same on a dashboard. Video URL is as below: https://www.youtube.com/watch?v=u1k0kplZlZY&list=PL2eqO0fbBIj8Ve\_TYrRC9xsNUBUcizGvZ&index=8&t=0s
Labels:
https://www.servicenow.com/community/performance-analytics-blog/single-score-report-with-percentage-using-performance-analytics/ba-p/2333030