I was trying to calculate the business duration in days using a script which used for breakdown mapping of 'business duration age' breakdown with 'business duration' field in Incident table.My daily collection job ran without any error but when I ran...
Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format. Duration fields, however, export as the value stored in the database, which is an integer value of seconds.T...
Hi, I think I may be asking too much, but I ideally need 1 report showing the trend of tickets raised on a weekly basis between 8pm on a friday though to 8am on a monday, by priority. I have figured out trend but you can't chose hour and day togethe...
Hi all, I'm trying to set up a Cascading filter, but can't get it to work. My reports that this filter should run on are on the task_sla and sc_req_item table. We have two choice type fields on the sc_req_item table (inherited from task table) call...
Hi All,We are looking for a solution in Reports. Can we create a Dynamic title for the report in Dashboard? Like we want the title as the dynamic format - "some name, +month/date".Any leads would be appreciated.Thank you!
We implemented the functionality to allow a user to either add a KB URL or the actual KB article content to an incident however it seems that it broke the ability to accurately report from M2M_KB_Task table because it broke the business rule on the c...
I had a subflow and i want to know wich flow or subflow call my subflow, there some table or any other way to descovery this information?I can track action using "Action Instances" table.
Hi All, I would like some help on interactive filters. Specifically, I'm trying to get a true/ false filter relating to a referenced field: I have a report showing Vulnerable Items, I want to be able to filter these Items based on whether the CI is '...
Hi I want to create a report that groups and counts projects with same business applications. This field is a List Collector so it can have multiple entries. What can I do to split this field for reporting purposes? I tried database views to join p...
I have built a Performance Intelligence clustering model -> Solution definition on the Incident table. And it also has built an ML solution. Now if a new incident record is inserted in the table and a train is updated and added to the cluster. How wo...
Hi there, Any way we can change the range of y axis measuring values.lets say if y axis has numbers in range of 100 like 100 , 200 , 300 etc - can I change it in range of 500 like 500 , 1000 , 1500 .. so on Am looking to increase the Y axis range ...
I have a dashboard with a report on it, of a list of my organizations applications and their related information. I'd like to add an interactive reference filter so that the list can be searched by application name, which is the first column in the r...
Adding the tags under the change request table and expecting the same tag to the displayed under cab agenda items table. Change manager will audit the change and provide the tags (audit complete/pending/impact etc.) it's depend on change audit in (ch...
How to create eg. following Dial-type of report where 1. Conditions: Status is 'in Production' AND 'Device type is empty' - eg. total number of devices which status are 'in production' is 4000 - total number of devices which are in production and ...
I am trying to scheduled a report in Servicenow using Run functionality : "Business calendar: entry start". But while saving it gives the error "Calendar field can not be empty". But I don't see the Calendar field. How do I achieve it?
