Hi All, I have created a report for getting all Requested items details. I have used sc_task table for gettiing information from CTASK level also.these are the fileds which i want -RITM-No.- Catalog-Item Name- Stage- State- RITM created- Requested fo...
Hello, Looking for some advice on how to create an automated indicator that shows trending on the average of the "Latest AQI" scores. In the kb_knowledge table there is a field called "Latest AQI". Great field, however it's a reference field so I ca...
I have a report that is displaying last day of previous month to last month in a monthly report I am running... My query looks like this: All>Status in (Resolved, Closed - Resolved, Closed - Duplicate)>Duration is not empty>Resolved on Last month>Dur...
Hi, Is it possible to apply a set of Coloring Rules to a single report only? Currently any rule I create automatically applies to all Single Score reports which isn't great. E.g. I have a queue where the score goes green when =< 15 and red if > 15....
Good Day. I was asked to do a report based on the SLA percentages, if the sla percentage time is less than 100% then its the green part, yellow just over 100%, and red way over 100%. Which meand yellow and red is breached, but they need to know how m...
I didn't arrive to find the mistake in my script /html to appear the color alternating, placed in rows of table . May you help me my jelly, see below , please ? In advance, thank you to help me .. ==> here, I use "ui page" . in the box " HTML" <?xm...
Hello!I need to create a report that will show us the number of requests processed by "assigned to" AND by request "type" (normal, emergency, etc) per week. I need this report to display several weeks at once (rather than a single week). As far a...
Hello, I am trying to use Multiple dataset to join 2 reports within a single report. As per docs i see the below image i need the same thing but unable to get that https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/pag...
Hello everyone! I am hoping someone can help me figure the best way to build a report that averages sprint points across multiple iterative sprints. Essentially, I'd like to be able to run a report and see what sprint team "X" is averaging for point...
Hi All, I have created an indicator named 'requested item closed monhtly' . I put the indicator in a widget and apply time series as 'By month sum' for that widget. When i drill down the widget it doesnt show any data for the breakdowns for some m...
I developped the module to display the scroll list of incidents, using System UI, UI pages and Widget. It works well. there are 3 columns of incidents : Number, state and short description.It displays so well but for state, the code appears. See belo...
Hello, I've been trying to figure out a reporting issue, but haven't had much luck with it. This report isn't showing all of the stacked by columns it should be for a certain user. It only happens when you use the "stacked by" option. If you remove t...
when i am creating a pivot table in report. how can i select the multiple fields in report row level.is it possible to create pivot table in performance analytics.
I have made a Incident Report with a second dataset to Request. What do I need to do to display Requests count on my data table? I can't seem to find any option to add Display Data Table in my Request dataset as I do for Incident. And how would I add...
I want to add cascading filters on dashboard level for widget. I am not sure how to add it on dashboard and will it work on widgets or not. Please let me know how can we add it and make it work. Thanks in advance!
