Order grouped by report
Hi everyone, I would like to now how can I sort a report that has been grouped by. I want to sort it in descending order. I suppose that I need to use pivot tables, but I don't know how. Thanks in advance
Forum Posts
Resolved! Please activate the Event Management and Service Mapping Core plugin to see service scorecard
Hi All, I am trying to view CMDB Serviceview from Performance Analytics dashboard & I am getting the one message on the dashboard for different report -"How to resolve "Please activate the Event Management and Service Mapping Core plugin to see servi...
Resolved! Users can't see widgets in a shared dashboard.
I'm sharing a dashboard (London Platform) with my team, but some of the widgets give an error saying they do not have permissions to view. Anything I'm missing or recommendations?
Reporting on Knowledge Articles used to resolve Incidents
I'm wanting to setup some reports relating to the use of Knowledge in our department. I've done a few but am stuck with the following; I'm wanting to report on how many Incidents have been resolved using knowledge. We have a separate report on gener...
Business Elpased Time List View for Incidents
Good day, I'm able to see the business elapsed time when I report on the SLA table, however when I report on the incident table I can only select 'business duration' for a column, however this doesn't appear to take into account pause conditions like...
Resolved! Report on the absence of data? (noncompliance)
A couple examples of noncompliance: - Who hasn't logged any timecards this week? - Who logged less than 40 hours in timecadrs this week, including those that didn't log any time at all? - Which projects do not have status reports this week? Hopeful...
Open vs closed incidents but with total numbers per month
Hello Community, I hope this is the right place for my first question. I have browsed all kinds of answers about a report that shows open vs closed tickets and I have made a good one myself, but it's not perfect and that's why I need help. I want a r...
How Can I Add New Dashboard to Navigation Pane?
While working in the ITBM PPM area, I made a copy of the Portfolio Manager Dashboard and renamed it HR PMO Portfolio Manager dashboard. I did this because I liked the out of box dashboard and wanted to keep it while adding two new widgets to the new ...
PA | Collecting data up to and including the previous month?
Hi all, I've a question which probably has a simple answer: If you are collecting scores for monthly Indicators, how do you ensure that the data which is returned does not include data for the month you are in? So for example, if I ran a job today, ...
Report: how to group by a variable
Hello! We have a report and have columns with service catalog variables. We have a need to group by variables and cannot find a way to do this (variables do not appear in the group by drop down list). Can anyone show me how to group by variable...
Resolved! Open Vs. Closed
Hello, I'm trying to create a report which shows tickets opened vs. closed for Months and also Years. Any thoughts on what is the best way for this to be set up? Thank you in advance. I'm looking at the Engagement Table in GRC.
Resolved! how are tables joined for reporting?
How are tables joined (either those out-of-the-box or via customization) for reporting in ServiceNow? I know that custom joins can be achieved with database views. However, are database views the object type that enables joining (i.e., dot-walking)...
Report on task created date
Hi All, I want to create a report to see how many incidents and catalog tasks were created each day for the week, Table - Task Type - Would prefer a pivot table Conditions - Task type is Incident or catalog task And created = last week So far i have...
Resolved! jpeg images on dashboard display only for me and not other users
I have a dashboard with multiple content blocks that contain jpeg images within the block. The jpg files are in the blocks as attachments to the block. The images display fine for me and I never had to do anything special to see them, but when I sh...
Using metrics to track number of field changes
I've got a requirement (currently using London) which I believe is a simple use of metrics, however I'm not finding any relevant examples and I haven't done a lot with metrics yet so the answer isn't jumping out at me. Most of the examples revolve a...