In creating a standard report, using the "Multiple Dataset" feature offered by PA Premium, I find that the original dataset inherits the name of the table that it is created against. Any ideas on how to change that? My first dataset is named "Inc...
i have created one database view to join incident and sys_journal_field table. If i put a condition as t1_element_id=inc_sys_id, then i am getting response. However if we have "y" number of comments on "x" incident, then that "x" incident is coming "...
Our team is attempting to produce an indicator that calculates the 'average number of incidents created per day for a given month', and the 'average number of incidents created per day for a given YEAR'. Requirements stipulate that we need to displ...
Hello, How are you using Performance Analytics for Incidents? PS. What's the difference (technical view) between Performance Analystics and normal Reporting module available OOTB?
HelloI have created a nice report against the Incident_Metric table. This allows me to query on when a ticket was transferred to a group and to show it as an opened ticket based on the transfer date. This means if a ticket was opened in August and wi...
Hello,I need to pull a report based the assigned date to any Assignment Group, we need a report where tickets are not updated since last 5 days these 5 days should be based on assigned dateI am able to pull the report but not able to filter as per th...
We have a variable set with Questions for Change Risk Assessment when Changes are logged via the Service Poirtal. The questions and answers are added to the Change form in the 'Change Varaible Editor'The Change Manager would like to extract teh Quest...
We've recently purchased Performance Analytics Premium and activated several of the context sensitive analytics plugins. When we try the "Context Sensitive Analytics - Change" dashboard (and the ones for Incident and Problem), we get no content. ...
Hi!I've created numerous indicators and none of them seem to show any results on the scorecard. I've created autometed and formulated indicators and none of them show data. Can somebody help me understand why? I' have indicator sources and a job coll...
Dear Experts, I want to change the indicator source in indicator, When i try to change indicator source,I got pop message "Indicator Source cannot be changed because this indicator has scores ". I have used this indicator in many of the widgets and d...
Hi,I have created few reports using Trend chart. We don't want the data table to be expanded in the dashboard since it consumes more space but we want the data table to be compressed in the dashboard. When the users need to view they will click on th...
Hi, I have figured out a script to export report using csv format which is great but i cant export more than 50,000 recordsI have tried the logic of looping through and exporting 50,000 records at a time and combine them at the end but specifying a n...
Hi there - I am working with Dashboards in an older release of ServiceNow, Jakarta. Is it possible to deploy a standard, out-of-the-box calendar widget for my Start and End dates? In other words, a little pop up calendar for a Start date and anothe...
I am attempting to combine the Incident table and the Task table to create a custom report in ServiceNow. When reporting using the Database view I can pull most of the information except the additional comments and work notes don't come over. The...
When Exporting records via XML from one instance and importing into another instance to preserve sys_ids, the Created and Update Date/Time stamps are identical from the source system. This drives the Reporting people nuts because in Snow Mirror (and ...
