- Post History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 04-25-2019 10:30 AM
Welcome to the ServiceNow Knowledge19 Pre-Conference - Performance Analytics Advanced!
This is a dedicated Community Article for class communication, collaboration, and fun!!
- 3,655 Views

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hello Everyone,
I am Jeff Manville. I'm a Servicenow developer at Harvard Business School. Really excited to be here!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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/
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Mark Johnson
Alexion Pharma
ServiceNow Program Manager (Operations & Development)
Performance Analytics Experience: Basic course.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Niels Melin Poulsen, BusinessNow, Denmark.
ITSM consultant, PA fundamentals and some experience.
Latest adventure ... Hoover Dam this week.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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...

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Ryan Roberts CSAA Insurance Group, Senior Developer. I've taken PA essentials, micro-certified. Excited to learn more.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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..
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Purbali Paul-Choudhury from UMass Memorial Healthcare
Senior ServiceNow Developer
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hello Everyone,
My name is Jamie Ott. I'm a Software Engineer for W.W. Grainger. Looking forward to this class!

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hello Everyone,
I am Leonid Khaylov. I am a platform architect at Daimler AG ServiceNow team. Looking forward into exploring new topics and features.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hello. I am Perry Newman from Charlotte. I am the NOC and Service Desk manager at Novant Health.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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);
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hey everyone I'm Mike Jeffers and I'm an Engineering Manager at CDW Managed Services.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Live long and prosper Spock from the Terran Universe.

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi, Module 4 is Report Building Techniques.
Can we expect any questions on this in the CAS - Performance Analytics exam?
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
This would have to be a custom role. None of the built in PA roles do that.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Are there are also PA solutions that would display the percentages permanently?
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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...
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.