I am working on a bar chart report that may require up to 4 tables in a database view and I am struggling to understand if it can be done. The report starts with the out of the box join between task_sla and incident tables to group business elapsed t...
Hi, I have a requirement to show the difference between RCA Delivery Date and Problem Record Open Date from problem record. I need to show the avg of those records with assignment groups in row and months in a column. Something like this: Any help w...
I have some calculated fields in excel which i will like to create in Performance Analytics
We have some incident reports that are grouped by assignment. If you add them to a dashboard, they do not display consistently for all users. For some users, it will only display 20 records per grouping. For another user, it displays all the reco...
Hi Guys, What does brown color indicate while dot walking- On CI rel table, I do a dot walk like: Parent.business service.environment (when I do this on left side , nothing comes in brown), same if I do on right side then it comes in brown and not al...
I am in need of a report that calculates the total turn around time with respect to every work order over a period of time.The logic is simple:Against every work order, I need to calculate the turn-around time (Date/time of creation - Date/time of cl...
Hello, I have set the fields to be recommended in the Ci Class Manager for CMDB Health dashboard configuration and Executed the JOB but the data is not reflecting the dashboard. Could you please suggest a script which can be applied in the JOB "CMDB ...
Hi, I have been trying to show the report in PA which can display my assignment group in rows and months in a column. I could have used normal reporting trend but the result of these rows and column cannot be calculated without PA. The result would b...
Hello all, I would like to know if it is at all possible to export the scoresheets for a specific indicator. For example, we have several manual indicators that were constructed painstakingly by importing data into the manual indicators by hand. ...
Hello all, I am a junior servicenow admin for my company and was looking to get your assistance with formulating a report. We would like to capture a total count of incidents that were initially assigned to our Helpdesk group, but then was then rea...
Hello there - I am using Istanbul.How would I export a Dashboard and all its report dependencies?I have admin access. I see these options, but can't get them to work. Export > XML Export > Export Set.In my test, after using Export > XML, the Impo...
Hi Team, we have a requirement to add color to the report field based on other columns of the report. For Example Asset Name Cluster(CMDB) Cluster(Platform) OS version(CMDB) OS version(Platform) vCPU(CMDB) vCPU(Platform) ABC XYZ-...
Hi All, I need a report to show all incidents where no additional comment have been added in x number of days e.g. 5 days I'm guessing I will need to create a new metric, but I have not done this previously, Does anyone have an example they could sha...
A user was filtering by two customer names. Some are normal names and some contain &. When they applied the filter it worked find and spit out 99 records. But when they tried to sort it would kick out all the records that contained the customer with ...
Is it possible to set up 2 indicator sources for one indicator? We would like to see all incidents and tasks assigned to various groups, then breakdown based on either incident or task? Currently - we have a widget for total incidents and a widget ...
