- 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-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 08:12 AM
Thank you, Bert! this is a big help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2023 12:03 PM
One more point, for the users, use a Breakdown for which ever field. I believe 'submitter' on the idea table is the field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2023 08:04 AM
If you are looking for something like the following:
then I have an update set with the components. However, I encourage you to review the links I have provided. There are also resources on developer.servicenow.com (trying to access the available Courses and tutorials is not working for me at this time). I'll attach the update set here if interested.