KPI showing % and list of service offering without incident or request in last 6 months
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago - last edited 3 weeks ago
Hi team,
I would like to achive below requirement could plz help with it
KPI showing % and list of service offering without incident or request in last 6 months
EIther using reporting module or Performance analytics
Thanks
Roopa
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @developer18,
To achieve the KPI that shows the list of Service Offerings without Incidents or Requests in the last 6 months, you can use the Reporting module in ServiceNow. Below are the step-by-step instructions:
1. Navigate to Reports > Create New
2. Set Up the Report Source:
- Report Name: List of Service Offerings Without Tickets (6 Months)
- Source Type: Table
- Table: Offering [service_offering]
3. Set the Related List Conditions:
In the Related List Conditions section, configure as follows:
- Set the filter to: Equal to 0 selected table records are related to a record on Offering
- Related List Table: Task → Service offering
- Filter Conditions on Task:
- Task type is Incident OR Task type is Request
- AND Created on Last 6 months
This ensures that only Service Offerings with zero related Incidents or Requests in the last 6 months are returned.
4. Select the Report Type:
- Go to the Type tab
- Choose List as the report format
5. Configure Config tab:
- Go to the Configure tab
- Set Group By: None
Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Created on or not on , If I give create not on last 6 months its giving me list of Service offerings , but not where 0 incidents there
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
The related list displays all tasks associated with a Service Offering.
I applied a filter on Task Type to include only Incidents and Requests, ensuring the list only shows relevant task types linked to the Service Offering.
Additionally, I filtered by Created on (Last 6 Months) to display only those Incidents and Requests that were created within the past 6 months.
To identify Service Offerings without any related Incidents or Requests created in the last 6 months, I used the condition:
"Equal to 0 selected table records are related to a record on Offering"
This setup ensures that the filtered result shows only those Service Offerings with no associated Incidents or Requests within the last 6 months.
Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Thank you for all details, and I need to calculate % of Service offerings not used in last 6 months , Can u plz help with that
% = only those Service Offerings with no associated Incidents or Requests within the last 6 months/ Total number of Service offerings
