Resolved! How to create Report for Average Handle Time of SCTASKs
Having successfully created report for average handle time of Incidents and Interactions, i'm trying to do the same for SCTASKs. I can get a count. I cannot get an Average Duration.
Forum Posts
Resolved! Performance Analytics - Collect data from 2 years ago
Is it possible to collect data from 2 years ago? We are trying to implement a quality index based on trending data from the last 2 years. When I try to collect data older than 6 months ago, I get a warning like the below and not sure how to change it...
Resolved! "Service Portal Log Entry" only keeps 90 days of data ?
Hi,I've noticed in my reports with regards to the Service Portal that sp_log only keeps 90 days of data.Can anyone point me in the direction of where I can change the retention time of this data?Thanks!Gwen
Change the default "group by" for a report
On our Helsinki system, we have a report on our customer satisfaction surveys which is defined as follows:When we run the report, we see our pie chart, as expected:In the box below the graph as shown, is a drop-down list with two options in it, "Metr...
Resolved! Can i set the color in chart ?
Hello all, I have a dashboard come with a few report in one page. Please see example below, the chart on top external is using blue (1st bar) the chart at bottom external is using Green (2nd bar) therefor, when all the report put together in a dashb...
How to make duplicate copies of 25 reports in bulk?
I want to make 1 copy for each of the 25 reports in ServiceNow to be used in a duplicate dashboard. However, I can't find anyway on how to do this in bulk. In the duplicate dashboard, it used the old reports from the other Dashboard. The duplicate da...
Resolved! How to report on how many requests were submitted via the portal?
Has anyone successfully figured out how to report on how many requests were submitted via the portal other than querying if requester and opened by are the same? Obviously, on INC, we can report on contact type but not finding anything for RITMs.TIA
Is it possible to Display percentages in a Report instead of Count
I have a requirement to display the Percentages in a report instead of count is it possible Here in the report in Y-axis it showing the count instead is it possible for Percentages and also inside the columns of the bar graph is it possible to dis...
Resolved! How to export dashboard in to PDF?
Hi team , I have few reports which is running on database view.Few of them are list type and two are column. I have added these reports into dashboard.The issue is I could export the individual reports as PDF but when I export the dashboard as pdf it...
report redirect URL substitute the & to &
Hi all, I have a problem with the URL redirect link functionality. when I specify a link, all the & writed into the link will be converten to &So the link that the system will generate not work... Can some have a solution to this problem ? Best ...
Resolved! Scheduled Reports are sending blank reports on email.
HI All, I have few scheduled reports which are sent through email. Since last few days they are sending blank reports. However when I checked the reports are creating data. Why are blank reports being received ??Please help
Resolved! Customising currency display in single score charts on dashboards. ie. $28,500,000.00 becomes $28.5M
Hi, I am looking for a way to change the display of dollar values in single score charts that will end up in a dashboard for executives. Specifically I'd like possible round/truncate the number to do something like the following: What currently displ...
How to change the label of a column in a list view report
Is there a way to change the label on a column in a list view? For example, you are pulling a report that has columns with the same name and you want to differentiate the different ones on your report by changing how they are displayed. Is there a wa...
How to create report on Interaction of incident ?
Hi, I want to create a report of the incident that having an interaction that will show you how many incidents having interaction or interaction count Thanks, Amol
Type of Incident.sys_tags field
In the Incident table, there is a field named "Tags" [name: sys_tags]. Looking in SNOW Tables & Columns, I was able to find the field. The type for :Tags" is equal to zero (0). Is the zero (0) and index number? if so,what type does the value "0" ...
