I have a chart that shows the number of Incidents by State. It shows them in order of decreasing number but I want it to reflect Open, On Hold and Resolved...... in that order. Is it possible to define the order?
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-...
I want to collect change records that are scheduled for the future. This is the date I want to aggregate by (Planned start date). How would I set up the indicator source?
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...
Hi All. I'm trying to create a reference type interactive filter to table ast_contract and want to select the column/field displayed on the dropdown, not using the default column/field. Just can't figure out how to achieve this as there is nothing on...
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 ...
I have a PA script (pa_script) table where I have a script and I would like to use logging to check the values I have there. Unfortunately it looks that I am not able to do it (in Istanbul release) as nothing is logged and even the scores are not col...
Hello,I am very new to Performance Analytics and need some help. We tried creating a PA Indicator to get the sum of a duration field of a few thousand records. For some reason, the dashboard shows 0 for the sum. Is it possible to add duration f...
