Top 5 Categories of incidents
Hi, How can i define a report that displays top 5 categories (Service / Service offering) of incidents for a week? Any advice much appreciated.
Forum Posts
How to export more than 32000 rows per sheet in xlsx or more than 30000 rows in csv?
Hi All,Hoping someone can point me in the right direction. I'm trying to export 342,000 records into a csv or xlsx format and not having much luck. I've updated all the entries I can at System Properties > Import Export to 500,000 for rows and 50,0...
Database view not visible to users when accessed from report
I have a sceanrio where database view is created on 3 tables viz. sn_hr_core_case, metric_instance and metric_definition and a report is created in one of the dashboards to show record counts from this database view. When a itil user pulls up this da...
Resolved! Average time to respond: Average function on the Automated Indicator returns weird metrics.
If we want to measure 'Average time to Respond' from the user's perspective, we should follow a 24-hour schedule, right? (real-time). There are a few tasks that to my understanding need to be done to achieve this: 1. First, create a new Metric to mea...
Reporting on created Metric definitions
I have been unable to determine how to report on the Metric definitions I have created. For example: If I created a metric for the "project" table and "state" field so that I could calculate how long the project was in each state. How would I pull a ...
2 breakdowns applied to a dashboard with several indicators
Hi, I have problems to order the information obtained from several indicators in my dashboard. Maybe anybody can help me... I have several indicators about incidents, and all them have two breakdowns at least: Company and Assignment group. I know t...
Resolved! Case Age
I need to create a report that displays the age of a case by the moment it was "Assigned To" an advisor. Is there a field that shows the date/time when the "Assigned to" is filled? Thank you,
Making a dashboard visible to non-roled users - how?
Hi everyone.I could really need your input on this, otherwise I fear I'll go bald from frustration very soon Here's the case:I've created a dashboard. The dashboard has 3 tabs.The 3 tabs contain report widgets.I've created an application menu at a pr...
Big Data Management Data Lake, Hadoop, Spark, predictive analytics
Dear Service Now Community, We are searching information about data availability and access, predictive analytics and other AI driven solutions within service now. For predicitive analytics we are currently working with data of our ITSM tool (not S...
What would be the number of acceptable users for Servicenow?
Good afternoon,We currently have a total of 57,751 users created on our production instance.I would like to know if the amount of users is too high and if this can cause any slowdowns.Also, can we know the number of users created per day from LDAP an...
Resolved! Target and Gap wont display when viewing a breakdown source on Indicator group
I have a dashboard displaying a Indicator group with several indicators. The target and gap displays correctly. If i select a breakdown source and element the values for target and gap don't show and I only see the Score. Is there anything I can d...
Resolved! User Experience Analytics - How to extract below KPI's?
All, Would need your help in getting below information from User experience Analytics Dashboard. 1. How do i get a trend of (# of Sessions that ended within 20 seconds) 2. Top 15 Search items and its coverage/availability of articles for those search...
multilevel pivot table show 2 aggregated values
Hi. I want to create a multilevel pivot table that shows the sum of monthly cost (this works) but I also want to show a total count next to each product on how many users has this product before it´s expanded. I do NOT have performance analytics b...
Resolved! I want to make a report with a table of search events
I want to create a report in the table of Name [sys_search_event].I can't select a table when I try to create a report.I thought it was an ACL setting, so I changed the ACL setting,Unable to create a report. Please let me know if there is any way.
Resolved! What is user Id, user index and hashed user Id in virtual agent dashboard users tab.Is it possible to get the actual user details from virtual agent dashboard users tab from user id and index. And in virtual agent dashboard, how NLU predictions are d
Hi What is user Id, user index and hashed user Id in virtual agent dashboard users tab.Is it possible to get the actual user details from virtual agent dashboard users tab from user id and index. And in virtual agent dashboard, how NLU predictions a...