anna_scheib
ServiceNow Employee
ServiceNow Employee

Welcome to the ServiceNow Knowledge19 Pre-Conference - Performance Analytics Advanced!

This is a dedicated Community Article for class communication, collaboration, and fun!!

Comments
xianoh
ServiceNow Employee
ServiceNow Employee

This is the correct External Import for Lab 4.3 Section B (Working with External Import)

Do not use the one in the Knowledge base. 

 

 

Manville
Mega Guru

Hello Everyone,

I am Jeff Manville. I'm a Servicenow developer at Harvard Business School. Really excited to be here!

 

Todd Volpe2
Giga Expert

Hey ALL

I'm Todd from SouthFlorida and I run the ServiceNow Dev meetup down there.  I've been working with SN for the past 4 years and I have over 12 years experience in these types of systems.

 

If you're in the area be sure to join us.

 

https://www.meetup.com/South-Florida-ServiceNow-Developer-Meetup/

juliesutton
Mega Expert

Hello and good morning.  Julie Sutton from City & County of Denver.  I lead the cyber security team and am a huge advocate for ServiceNow in my organization.  I do most of the training for my coworkers and have started teaching others how to use performance analytics.  I'm here to learn more advanced techniques and hopefully be able to teach this more effectively in more organization.  My most recent adventure is that my husband and I are opening a new business!

Konstantin7
Mega Guru

Konstantin Kazantsev
Mission Health | HCA Healthcare North Carolina Division
IT Change Manager and ServiceNow Administrator

Needing to get advance training for performance analytics.

Working on migrating change templates from one instance into another without using the system IDs.

 

davidslin
Tera Explorer

Hello, I am David L.

I am a business analyst at the University of Washington. I have been working with Service Now for 5 years and PA for 3 years.

Please feel to reach out as a fellow user in Higher ED.

Kevin Nasir
Tera Explorer

Kevin Nasir - Texas A&M University

Lead Software Developer

Reason - become more familiar with the options available for a multi company organization such as spotlight data seperation.

crew5man
Mega Explorer

Mark Johnson

Alexion Pharma

ServiceNow Program Manager (Operations & Development)

Performance Analytics Experience: Basic course.

Subbu Palaniapp
Tera Contributor

Subbu Palaniappan from Hitachi Vantara

Role: ServiceNow Platform Owner

PA Exp: Used PA mostly out of the box, need more knowledge to use it extensively.

nielsmelinpouls
Kilo Contributor

Niels Melin Poulsen, BusinessNow, Denmark.

ITSM consultant, PA fundamentals and some experience.

Latest adventure ... Hoover Dam this week.

mikegorski
Kilo Contributor

Hi everybody,

 

I am Mike Gorski a ServiceNow Developer for almost 3 years...attending my 2nd Knowledge conference...hoping to network and find some answers about issues we are having...

 

jmiller0666
Tera Contributor

JM Miller, ERIE Insurance, ERIE PA - Summer is great, the rest of the year is cold with LOTS of snow.

Service Measurement and Reporting Manger

Community Alums
Not applicable

Eddie Shigeta - Hitachi Vantara

HR Product Manager - responsible for the HR scoped App 

Fundamental Knowledge of PA

I want to understand PA on a deeper level so that HR can build advanced analytics on the platform and continue to build on exec dashboards

Ryan Roberts1
Kilo Expert

Ryan Roberts CSAA Insurance Group, Senior Developer. I've taken PA essentials, micro-certified. Excited to learn more.

victoriamorales
Mega Explorer

Hello everyone, My name is Victoria and I'm with Accenture. I am a tester on my current project, but also help with the Business Analyst. I've been working with ServiceNow for roughly a year and a half. Very excited to get a better grasp of PA from the advanced course. 

pneuvil1
Mega Guru

Paul Neuville - Detroit Michigan. 

Worked with service now since 2010. Wrote my first program in 1976.

Wrote a rollup pa viewer that rolls up scores from pa_scores to the upper management structure

John Lamberta
Tera Explorer

Name/Company: John Lamberta - Cerna Solutions

Title: Consulting Services Manager

Experience: Some experience configuring PA for customers

Reason for attending: Interested in data analytics and presentation, want to know more advanced capabilities of PA

michaelgracie
Kilo Explorer

Good morning.  My name is Michael Gracie. I am the Senior Technical Advisor for End User Operations, OIT, Department of Veterans Affairs.

 

Always find something new to learn about ServiceNow and PA.. 

Purbali2
Kilo Explorer

Purbali Paul-Choudhury from UMass Memorial Healthcare

Senior ServiceNow Developer

mdandrade
Kilo Contributor

Hi everyone,

 

My name is Matt D'Andrade and I am a SR. ITSM Analyst (ServiceNOW Admin) at Under Armour. I took the Fundamentals class and have built several dashboards, indicators, etc. I want a deeper understanding of the PA application, and obtain certification after taking this course.

Frank38
Kilo Explorer

Hi, I'm Frank Lanier with The Boeing Company.  I've been working with Service Now/PA for about a year.  Looking forward to taking a deeper dive into the capabilities of PA.

Aaron D
Tera Explorer

Hello everybody.

 

I'm Aaron from Salt Lake City, Utah, and I'm a developer at Western Governors University. Happy to be here, looking forward to a PA deep, deep dive.

jamieott
Giga Contributor

Hello Everyone,

My name is Jamie Ott. I'm a Software Engineer for W.W. Grainger. Looking forward to this class!

Robert Webb1
Tera Expert

Hello all, I am Robert from Nashville. I work for GSI, Inc which is an Atlanta based services company. I am primarily a technical consultant specializing in Platform, ITSM, and PPM implementations. My experience with PA has been limited to building dashboards for customers for the applications mentioned above. My last adventure is actually this one as it is my first time here in LV!

Geoffrey Minshu
Tera Explorer

Hi, I'm Geoff Minshull working for GSK and we will hopefully be implementing ServiceNow soon.
I have taken the PA Fundamentals and now progressing to Advanced course to further my PA knowledge.

 

Leonid Khaylov
Tera Explorer

Hello Everyone,

I am Leonid Khaylov. I am a platform architect at Daimler AG ServiceNow team. Looking forward into exploring new topics and features.

Josh6
Tera Explorer

I'm Josh Andres

 

I'm a Solutions Architect with Aptris with 9 years of experience with ServiceNow

 

I'm here to learn how to provide more advances solutions to my customers

 

My last adventure was taking a week long trip touring Europe

Bart Como
Tera Explorer

Hello everyone!

 

Bart Como from Deloitte

Role: ITSM manager also responsible for Service Portal / Service Catalog.

Reason for attending: I'm looking to further develop my understanding of PA in order to have more powerful dashboards. 

Perry Newman
Kilo Explorer

Hello. I am Perry Newman from Charlotte. I am the NOC and Service Desk manager at Novant Health.

grant_higgins
Tera Guru

Hello all,

I'm Grant from Salt Lake City, working for Western Governors University. Been on ServiceNow for approximately 3.5 years. Currently working as a developer of custom and OOB applications in our instance. 4th year at Knowlege, looking forward to a great time!

anna_scheib
ServiceNow Employee
ServiceNow Employee

Script Code for the Metric Duration in Hours Script: 

(This script can be downloaded from your KB by pressing Edit in the KB article and opening the KB article in Form view)

 

var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};

var hours=function(x,y){return diff(x,y)/(60*60*1000);};

 

var endDate = current.mi_end;

if (!current.mi_end && !current.inc_resolved_at) 

endDate = score_end;

else if (!current.mi_end && current.inc_resolved_at)

endDate = current.inc_resolved_at;

else if (current.mi_end > current.inc_resolved_at)

endDate = current.inc_resolved_at;

hours(current.mi_start, endDate);

anna_scheib
ServiceNow Employee
ServiceNow Employee

Performance Analytics Certification Info: ServiceNow Training and Certification Main Page

Performance Analytics Application Specialist Exam - Exam Overview and Description

Micro Certification - Performance Analytics Micro Certification

 

Jeffers
Kilo Contributor

Hey everyone I'm Mike Jeffers and I'm an Engineering Manager at CDW Managed Services.

Jon Durden
Tera Expert

Hello, I'm Jon Durden. I'm a ServiceNow admin with WestRock. I've been working with ServiceNow for about a year and this is my first time at Knowledge!

lesleyklinger
Tera Contributor

Lesley Klinger

ITSM SR Analyst for The Hershey Company. 

Looking for folks using Demand, Change/Release management - anyone integrating with SAP Solman 7.2 for ChaRM and Tech Monitoring. 

This is my 2nd Knowledge event. 

We've been using SN since 2016.

Currently upgrading to Madrid.

justin24
Kilo Contributor

I have a PA roles question in case anyone has insight:

As the admin for PA, I'd like to enable business unit owners to be able to create their own widgets without having access to modify our standard indicators. 

Does anyone have experience creating a role which allows indicator Read only access and widget Write access?

 

Thank you!

Justin

UC San Diego

pneuvil1
Mega Guru

Live long and prosper Spock from the Terran Universe.

xianoh
ServiceNow Employee
ServiceNow Employee

Check out this for KPIs  

 

Free to sign up. 

 

http://kpilibrary.com/

Simon Rimington
Tera Explorer

Maybe.. pa_power_user

Typical persona:

Business analyst. Understands the business use cases for Performance Analytics and the requirements for indicators and breakdowns.

Authorizations:

  • CRUD indicators and breakdowns.
  • CRUD widgets
  • Add Performance Analytics widgets to dashboards.
  • CRUD text index configurations for text analytics.
  • CRUD bucket groups.
  • CRUD indicator groups

Roles

 

cloudyrobert
Kilo Guru

Hi all--Robert Elliott from St. Jude Children's Research Hospital in Memphis, TN. 8+ years with ServiceNow, 2 years with PA. Looking to learn how to use more advanced concepts to improve the insights we're able to provide into our data.

David Brookins
Kilo Explorer

Hello everyone.  My name is David Brookins and i am with NTT Data Services based in Plano, TX.  I am the ServiceNow Platform Delivery Director for a large hospitality client.  Looking forward to this course to enhance reporting to product owners and executive leadership.

Geoffrey Minshu
Tera Explorer

Hi, Module 4 is Report Building Techniques. 
Can we expect any questions on this in the CAS - Performance Analytics exam?

anna_scheib
ServiceNow Employee
ServiceNow Employee

This would have to be a custom role. None of the built in PA roles do that.

dvd
Tera Contributor

There was a question from @jamieott on where to find information on the file limitations for importing external data from MS Excel for reporting.

Here is the link to the Madrid documentation: https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/reporting/task/create-report-with-imported-data-source.html

Community Alums
Not applicable

Hey everyone, my name is Kaylin and I am a ServiceNow developer out of Salt Lake. I have a problem I'm trying to solve at work and I'm wondering if anyone here has ever had a similar use case and could provide any potential solutions using PA or otherwise. Basically, a manager in one of our departments is not able to use ServiceNow reports because it is lacking two crucial criteria for his needs:
1. Display percentage data labels without having to hover over the columns (display them permanently)
2. Display a goal line that displays the percentage goal their department is trying to meet each month
I've attached an image of his report that he has created in Excel (updates monthly via ServiceNow data exports).
We could of course create something custom but would prefer to use the oob functionality of PA/reporting if possible. Thanks all. So excited to be back at Knowledge!

anna_scheib
ServiceNow Employee
ServiceNow Employee

This is definitely something that can be achieve with a PA Indicator. The goal is visualized with a Threshold. And you can use a Time series chart with a Columns visualization to show the data.

A reporting widget may also be used, although there are no Thresholds in Reports.

jasoncoleman
Tera Explorer

Regarding Spotlight - Is there a way to access Spotlight information from the Incident table view, such as Incident Open

The Spotlight dashboards and table are great for management or a queue manager, but for engineers that are working in a NOC that are looking to see what ticket they need to work on next, this information could be very valuable.  Something like the ability to see the Spotlight score as a column or the ability to add a graphic or color to the record in the table to show that it hit a Spotlight threshold.

 

The other item would be an ability to have multiple thresholds, so that you could have Red, Orange, Yellow levels of Spotlight.

Community Alums
Not applicable

Are there are also PA solutions that would display the percentages permanently? 

anna_scheib
ServiceNow Employee
ServiceNow Employee

These are very interesting use cases.

On the multiple thresholds - there is a single Threshold per Spotlight Group, so you can configure multiple groups, or, run the job multiple times for each Threshold value - BUT, every run will delete the previous Spotlights.

Regarding making the Spotlight Info available to engineers, you could create a custom UI Action that opens the related Spotlight Dashboard.

To group Snapshots with different Weights into different "buckets", maybe you can use Report Ranges? And make that another widget on the Spotlight Dashboard.

Just some ideas...

 

 

anna_scheib
ServiceNow Employee
ServiceNow Employee

Using a Time Series widget, you can label the X/Y axis as needed. Mousing over the data points will always display the corresponding value and unit, say 50%. You could also add Data Labels, but that tends to crowd the chart.

Version history
Last update:
‎04-25-2019 10:30 AM
Updated by: