Resolved! How to show report data for 3 weeks back
Hi, I would like to build a report of incidents created within the last three weeks. How can I do this in the criteria>
Forum Posts
I need to calculate the median of the response time and resolution time for all the incidents of a month.
I need to create a report/score which will show the median value of the response time of the resolved incidents for a month. Has anyone done something similar or can guide me on how to achieve it?
Why is the target and threshold not showing on widget?
For some reason, the target and threshold is not displaying on the widget I created. "Show target" and "show threshold" is checked on the widget configuration. On the indicator, the targets and thresholds are configured for both, time series empty an...
Resolved! How can I get a single score report that captures average daily incidents opened on a month to date basis.
I am trying create a single score report that is on a dashboard that shows the average count. I am looking for an average of incidents opened daily on a MTD basis and then average incidents opened monthly for the previous three months. Once I choose ...
Data through REST API into power bi
Team, Need help, I am trying to get Servicenow data into power bi using table API. I am somewhat successful but came to a roadblock as I can only able to extract 4000 records in a single query. Although I have read that there is a default limit of 10...
using the relative filter for a date field, not all the options appear
Trying to create a report and using the "relative" filter on date fields. I only see "before" or "after" as options, but there are more that should be available. What is the issue.
Get Incident Priority breakdown pa report for my assigned assignment group
Hi Everyone, I got a requirement to create a PA dashboard containing couple of reports based out of my assignment group. For that I want to create a priority breakdown report showing data of all the incidents which are assigned to my assignment gro...
Performance Analytics - job error
Hello everyone,We're trying to figure out why we are getting the following error in one of our job logs (see below). Any ideas?The message is super vague.Thanks!!Error collecting for 20160516 java.lang.NullPointerExceptionat com.snc.pa.dc.Script.getS...
Clustering definition solution is not getting trained
I have created a clustering solution definition after installing both the predictive intelligence plugins. But when I click on "Update and train" UI Action ML solutions are generated but in active false state and its showing "Configuration OR Network...
Reports with very long execution times.
Hi All, In the HealthScan Report it show there are more than 2000 reports running longer on average as 10000 milliseconds. What are the possible steps or best practices to resolve this . Also there are 2-3 reports which show No record to display yet ...
In PA Widgets containing multiple Indicators, how to stack specific indicators with specific other indicators
Hi Folks, I have 6 indicators in a widget. 3 contain positive dollar values, and three contain negative dollar values. However, the end user wants the negative values displayed in the positive domain, so I used a formula indicator (value*-1) for th...
Resolved! Is there a way to create read only reports?
Hi, We have reports that need to be shared with users in order for them to be run, or seen in dashboards. When we share the reports, the user has the ability to modify them. Is there a way to create a read only report that can be viewed by a user b...
How do I report Total Incidents per day in Reporting
Hello I need to report on incidents logged and resolved per day for the past 4 weeks for each region. When I use trend types per day and it displays the x-axis as SAME DAY, 2-5 DAYS, 5-7 DAYS. I would kiek x-axis to show each day for the past month...
Resolved! Linking multiple dashboards as separate tabs in one dashboard (Istanbul)
Hello ServiceNow experts,Is there a way to link existing dashboards into one dashboard in PA? We just upgraded to Istanbul and it's hard to find a way to do so. It was an option in Helsinki release. I want to add three dashboards in separate tabs in ...
Resolved! Creating PA Script for an Indicator (metrics) that calculate the Avg time for Assignment Group handling
Hi! I want to Create an Indicator based on the incident_metric table that shows the AVG Handling time for Resolved Incidents - and Breakdown on Assignment Groups. I wonder if and how I can configure a PA Script that looks at both the Duration of the ...
