Hi, all reporting (and performance) experts! In case you have tables with loads of data and you need to create reports that should only include some of the records. What is the best, and most efficient, way to create the report? Does it make any diff...
Hi All, We have a requirement to calculate the metric on Requested item table to calculate time taken between "Opened At" and "Approved/Rejected". This we can calculate using metric definition on approval field i.e. when it changes form Requseted to ...
Team, I am struggling to create a formula indicator to calculate the percentage of Incidents that have been reopened. I don't see an out of the box indicators (automated or Formula). Any advice is much appreciated.
I haven't been able to find a thread on this one but some seem close. I want to create a report that shows the number of Active Incidents each day, regardless of when the incident was created. I've tried various options but keep getting the number of...
I need to create a report of Assignment Group Hardware for last year which should be grouped by Month.I created a report but unable to group by monthly basis
Hi Folks, we are rolling out surveys in ServiceNow, and I am at a loss for viewing survey results. Is there any OOTB reporting on surveys built on the platform?Since our HR and IT teams will use surveys, how do we ensure HR does not see IT's survey ...
Issue Details :We have created the below Dashboard with Widget and Indicator to show the 'Number of Open Incident' based on the Monthly Sum with 'Age' Breakdown.The count on each bar does not match the count of records when we drilldown to see the Sc...
Hi all, did anyone ever encounter this problem: I updated the title of an interactive filter through an update set from a DEV instance. To do so I changed the name field in the interactive filter record. On the DEV instance, that did the trick and th...
User wants to see all Incidents transferred from any of his groups back to the Helpdesk, where they get closed.I'm filtering on Assignment Group metric definition, but results are understandably duplicated (multiple Updated(mi_sys_updated_on) ) value...
I need a way to know which Assignment Groups / Fulfillment groups are associated with which Workflow / Workflow Activity I am going to change the name of an assignment group so that would mean it will break my workflows that have catalog tasks for th...
In would like to get on 1 report -the number of incident tickets created per month (column) -the number of incident tickets closed per month (column) - the number of open tickets (backlog) at the last day of each month (line) See enclosed what I expe...
Hi all, I need your help. I want to create a report of change task, with the next information: Number, created, title, description and change request number, filter by Coordinating group (X and Y); because I need all changes task with their change re...
Hi All; I need to generate a PA report with the breakup of the assignment group, assigned etc. It should show how many tickets came to that group on that day and how many re-passed to another group from that group. I tried to build on the Incident m...
Hi! I would like to change my calendar report to start showing meetings/events that start at or after 8am. Right now it begins at 00:00am so there is a lot of wasted space since our events don't begin until 8am. Thanks!
Hello - I am trying to create a report that will give me % of incidents that has a problem. The issue of grouping by the Problem field is that it shows empty and a bunch of problems instead of a group of problems. I wanted to use function field avail...
