- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2023 02:27 AM - edited 02-22-2023 02:32 AM
Hi, i have very little experience in Performance Analytics.
We have a requirement to create a 1 PA widget in Dashboard containing KPI in Idea table checking whether customers A, B, C (Customer is a reference field in Idea table that is populated by user) are creating 4 idea records per month and need to display this in like percent of what is achieved as of the current date
Example. If Customer A created 2 idea records, it should show 50% for customer A, in that same widget, if Customer B created 4 idea records, it should show 100%. It should display the percentage for customer A, B, and C (bar chart) and when clicked per bar, it should display the daily history like when the ticket is created etc.
Please help me in setting this up.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2023 10:39 AM
1. Create an Indicator source for the Idea table:
Set "Facts table" to 'idea', "Valid for frequency" to "Monthly", and one Condition 'Created', 'on', 'This month'
2. Create a Data Collection job:
(I haven't found documentation of how to fill out the form, but there are videos available.)
See attached screen shot
Set the timezone and time as desired.
3. create an Indicator:
"Unit" can be '%' (On General page), set "Indicator source" to the indicator source created in Step1. Fill out the remaining fields similar to the following screenshot
Once that is working the way your want. You can refer to:
I hope the above helps. Please see:
https://www.youtube.com/results?search_query=servicenow+performance+analytics
for more assistance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2023 09:07 AM
Let me know if you want the update set, it is a start. The included widget needs to be added to a PA Dashboard. The Data collection job may need adjusting for your requirements. I have tested it in a San Diego and Rome instance. it was developed on Utah.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2023 09:09 AM
Yes please! Kindly send me the attachments. thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2023 10:15 AM