How to Calculate the percentage of Issue Rating in Issue Management Module in ServiceNow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2024 11:12 PM
Hi Team,
I have a OOTB field called issue rating. It contains certain values for example 1- High. I need to create report which contain Score, Level ,Rating, Adjusted Rating. The field level rating and adjusted rating are not present in Table.
How to put that in the report.
For Example
Score, Level, Rating, Adjusted Rating
1, Low, 1, 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2024 11:40 PM
Where are those fields stored? And is that related to the record itself? Then you can add the fields by dotwalking to them. Otherwise you will need to create a database view with the table(s) they are stored.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-14-2024 12:14 AM
These fields are not present in Table. How we can achieve this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-14-2024 12:23 AM
That was my question: where are they coming from?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-14-2024 12:30 AM
We have to enter the manually calculate the value. In my previous example I mentioned
Score, Level, Rating, Adjusted Rating
1, Minimum,0, 1
Rating we are providing based on the score
Adjusted Rating we are providing based on the score.
The value is for one single record.
If I want an average then I need to calculate the average for the score.
Kindly help me on this.
