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...
Hello, I am currently trying to create a report that shows the results (string value) of a certain question within a survey. I have it setup to look at the asmt_metric_result table and want to have it Group by string value. Unfortunately I cannot...
Hi, I am trying to create a report which displays all incidents closed in a 24 hour period between yesterday 7am and today 7am. How do I go about building this condition for the report? Thanks in advance.
I'm looking to create a few reports from the words that are listed in the Description box. For example pulling all tickets which mention the word 'complaint'. I have been told that the only way to do this is via keywords. I'm pretty new to service n...
I am trying to create a widget with an Indicator that would show the time worked by incident priority. I can't seem to find how best to create this. Please can anyone help or provide a guidance? Thank you