I'm creating a report using the Time Card table to replicate one of our reports from another system (picture below). The grouping is on the user (I marked out names in red), and we report how much time they spent on each project (marked out in black)...
Hi Friends, we would like to know below things please help me on it. We have so many dashboards, so our management wanted to know that, which dashboard using by (not owned by) which user, if possible when, and how many times etc etc.. if it is not po...
Hello, There is a nice dashboard located here: System Web Services > Rest & Soap API Analytics > Usage by Requestor It takes us to a dashboard with a drop-down to filter by the requestor, such as MID Server, or any other user account that uses the A...
Can we call a Dashboard in Schedule report so that all the snapshot which is visible on the dashboard could be emailed to the managers ?
I have an example custom interactive filter example that applies the dashbpoard handler, but just before hand calls a setDefaultValue function: SNC.canvas.interactiveFilters.setDefaultValue({ id: filter_message.id, filters: [filter_message] }, false)...
Hello all. I'd like tu use an interactive filters (OOTB) on a custom dashboard in order to filter a custom report ( a bar chart) that shows data from a database view (OOTB, incident_sla), but it doesn't work. All the necessary checks are flagged. Do ...
Hi to all. I need dashboards for Service Desk. Are there any standard dashboards in Service Now? (PA or Reporting)How to make real time reports for Service Desk without losing capacity? (more than 100 employees at a time)
Hi All, I'm having an indicator on the metric_instance table. this metric holds in the 'field value' field two sys_id's separated by comma (string field).And I have an indicator that has two breakdowns one is on the users the other is on the groups. ...
Using the Data Table widget in the Service Portal that comes with Helsinki. Cloned it so that I could make it work for me. I added the table name (change_request) and added the fields I wanted to see. That however doesn't seem to be what that f...
Hi Is it possible to create an interactive filter that has a default value of Empty / NULL? When the Interactive Filter is a choice list, on the dashboard you can select "--None--" as one of the options. However i can not see how you can select this...
Hello Everyone, We have to create a report in which we want to calculate / find the actual time when the ticket was breached. I have used the below fields but have some issues like below : 1) Original Breach Time --> This field calculates breach tim...
I am new to servicenow analytics, and I was asked to create a widget that displays the percentage of problems that pass a certain test. The test is this: If problem was created within the last 7 days and Root Cause Category is not “blank” and Task St...
Hello, I initially was able to get help to join the Project and Project Status table through a database view. This helped me list all the projects whether or not it has a status report or not. Now, I need help on to just show the latest and greatest...
Hi Community! I have been struggling with some script include calls when writing a report on the discovery_device_history table. I am trying to provide the sys_id for the latest discovery_status record for a given IP address from the discovery_device...
I am trying to create a dashboard report to show the number of tickets that come into our queue. We are a triage team and therefore we do not resolve all the tickets in our queue and most are reassigned. if I create a report using incident as the ta...