Hi Folks, I need to build a report for a specific team's catalog items, and it needs to list their average turn around time and average time to close. I am not sure where to start in my report, to accomplish this. Is there an OOTB metric to accompli...
Hi Community I'm trying to create a report that show Incidents and Requests tickets for a certain owner group. So far so good, but I also would like to show the tickets if the Owned By Was that group. I cannot find such operator. Why I want this is ...
Is there a way to sort the individual stacks or categories in a stacked bar chart to go from largest count to smallest count? For Example I'd like this stacked bar chart to go from the Service Desk category on the top to Database category on the bot...
Hi Team, I have a Requirement to combine two records into a Single Record Directly report approvers that are configured for specific role(Object). Add role, show first and second approver configured for role, in one list (one entry per role) Please l...
Hello, Is there any way to plot multiple indicator on same chart as shown below,
Hi, Our users are facing an issue while accessing the asmt_metric_result table from a dashboard as "Access to this content denied based on report_view field ACLs" even though the report_view ACL's are not active. The report_view ACL's are having asse...
Hi, I'm having problem with "Multilevel pivot tables". How can I create Multilevel pivot tables like this: The requirement is to summarize the number of incidents by category of the months. Has anyone ever done something like that?
I'm creating an indicator source to retrieve the number of cases created during 12 hour period. I have specified the conditions and when I do preview it gives the correct count of cases created. However when I create an indicator and attach to a data...
Hi Expects, I want to create a Report based on which devices users are using when they connect to the service portal. Mostly if I can store a device name of user he is connecting from in user table when user login's to ServiceNow I have some data in ...
Hi All, I've been asked to come up with a report that provides duration between states for a task (sctask). Example - If a task was in state of Pending, and then later got changed to Pending Vendor, how long was that duration from Pending to Pending ...
Hello,I am a new here. I have a question. Can i get list of all script what have ran when i opened a ritm or task?
Hi, I have a "Multi-level pivot table type" report on table "resource_allocation_daily". Where it is supporting only 5 rows and 3 column. So I want to populate 2 field value by concat with below function in report:- "glidefunction:concat(u_project_de...
We have a P1 incident response SLA that attaches when a P1 incident comes into the system. Once the incident is assigned, the SLA completes. Now when the assigned person looks more into the ticket htey find its really a P3 not a P1 and changes it. ...
Hi All, We have a customer requirement where they need a common report for multiple tables. One of the requirements is that they need a report for all the Incidents and Service Requests assigned to a particular group. Could you please help in the so...
Hi All, We have OOB for the Survey Net Promotor Score report but I want to create a report like the same OOB and I created and its showing all the value but the Net Promotor Score score is not displaying can one guide me how to display the NPS valu...
