how to get only latest record in database view
Hello Is there anyway to get latest record in database view. i have created a database view but its showing duplicate records. i need only unique records, is it possible.
Forum Posts
Tracking and Reporting on Dashboard Usage in ServiceNow?
Hi PA Community, I have a requirement to track and report on dashboard usage in ServiceNow. I am well aware of the fantastic step-by-step blog by @Adam Stout - Tracking and Reporting on Dashboard Usage in ServiceNow Before going the custom table crea...
How to sort data from ascending to descending order(Maximum to minimum data count) in Trend chart or pivot chart? Is that possible in reporting?
I have a requirement to show top 10 customer list based on quarter wise/month wise. I can extract the data and show it in trend graph as below. But how can I sort it from maximum to minimum count. (or) how to sort in Pivot chart? It is automatica...
Resolved! How to create Single Score report to show duplicates
Hello, I would like to create a single score report to show the number of duplicate user accounts. I see Count and Count distinct, but I'm not sure how to filter on those with Count greater than 1. I'm sure its something very simple that I'm missin...
Is it possible to track incident ticket reassignments?
Hi all, Our Service Centre Manager wants to get an understanding of how many incident tickets were originally assigned to the Service Centre assignment group but were passed onto another team to action and/or resolve. Is it possible to produce a repo...
Monthly Indicator - how to filter to current fiscal year.
Hi team, I've created a monthly indicator to show project planned cost by monthly.As the fiscal start month is April, I would like to have a line starting from April. Although I have set the Time Series to "Fiscal year to date SUM", the line still sh...
Schedule report on first monday of every month
Hi, I am trying to schedule a report that needs to be sent on first Monday of every month and I have used a below query, Can someone hep me understand whats wrong in the query. function checkmonday() {var gdt = new GlideDateTime();var day = gdt.get...
Created interactive filter that selects agents (assigned to) data based on the manager
Hello everyone, I am trying to show data for Agents that are assigned to cases. For simplicity let's just say I want to display how many cases an Agent is assigned to which is simple enough by itself. However instead of creating an 'Assigned to' inte...
Report looks different if placed in Dashboard (only with one user)
Hi friends I do have a weird case with one user. If this user opens the report, it looks like this: If the same report is placed in a dashboard, this user sees the report different With other users that I've tried, it looked normal. I thought t...
need help to create report which shows number of days between when Ticket was Opened and Closed for a particular month
need help to create report which shows number of days between when Ticket was Opened and Closed for a particular month For e.g I can see using attached query that there were 1500 tickets created and closed in Jan 2022 however can I create a report...
how to add multiple columns in single Report?
Hi Experts, In a table there is three columns Containing integer value, while creating a report or dashboard I want to show all three columns SUM in a single Bar or list. Please guide. Eg. C1=2,C2=3,C3=5 IN report or Dashboard, I want SUM OF C1,C2,C3...
how to create report showing number of tickets assigned to certain assignment group in a month
HI Need help with following how to create report showing number of tickets assigned to certain assignment group in a month For example number of tickets service desk assigned to application support group for the month of Jan 2022 Thanks in ad...
Hi, i am doing a queue manager role in service desk team. Is there any report in servicenow, to get how many of the incidents i have assigned on each and every agent name?
Hi, i am doing a queue manager role in service desk team. Is there any report in servicenow, to get how many of the incidents i have assigned on each and every agent name? Agent sometime move that incidents to 2nd level groups or can resolve or hol...
Resolved! Give editing access to a report I built
Hi Folks, I've created a report for a stakeholder, and I would now like to give them editing access to the report, so they can take it over and maintain it. I am not seeing a direct way to give this user editing access to maintain my report. Is this...
Resolved! Counting number of times a field is changed from one option to a selection of other options
This is my first time doing anything with reporting, so please excuse me if this is a simple question. I need to be able to track the number of times a specific field is changed from one option to one of a set of options. I also need it to be history...
