I would like to create a yearly report that shows all the tickets my team members opened, closed, resolved, or updated any work note information on. I can easily generate a report to show number of tickets opened, closed, or resolved. What I can't f...
How can I reference the fields in the sc_task table from the sc_req_item_sla or task_sla tables? I built an SLA report using the Task SLA table and I need to add several fields of data to my report from the sc_task table. The fields are as follows: ...
Hi Folks, I was trying to do an if else in formula indicator but its not really working as intended.The idea was that if a reference indicator = 0 then return 100 else proceed with the formula indicator1/indicator2.Here's the formula:var sla = [[indi...
I have two import tables and two target tables. One import table is extending the other import table, so they are using the exact same columns. The target tables are completely separate. I have a scheduled data source import set up for the "parent" i...
Indicator Source : Daily Job : Daily. Widget timeline : By monthly sum + Widget visualization : Line I ran the historical job for Closed Tickets. Result : It seems like the scores collected daily are being summed up and showing a very high number wh...
How do I put custom duration for a report of Aging incidents for example 2-3 days, 3-5 days, 5-10 days etc.
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 ...