Hey I am looking to pull some metrics from an assignment group. I would like to see the percentage of tickets that each engineer picks up from that group. Example - 10 tickets in London unassigned group, If John Smith picks up two of those tickets I ...
Hi, I have created a interactive filter, for Software Owner. In the related lists i have added tables and fields, PFB screenshot of interactive filter i created. i have created a report for Software entitlements. The owner is referenced on software...
Looking for best practices for presenting a List (type), Scorecard (visualization) for month over month reporting on an executive dashboard. I have two groups at this time. One that shows 'by month avg+' for the percentages and averages and a secon...
Hi,Is there a way to lock down time zone when using Performance Analytics so regardless of which time zone the viewer is at, it will always show the result based on a particular time zone
I want to create a report that show hierarchical data with multiples aggregations.With a multilevel pivot table I've got the hierarchy but i can´t visualize multiple aggregations.And with performance Analytics I've got multiple aggragtionbut I have n...
Hi Team, We have created a database view out of 2 tables i. Incident ii. ml_cluster_detail A report is generated on this table , the requirement is to provide access to report and the data who is having ITIL role. We have tried all the possibilities,...
Hi All, I've requirement to get a report on specific table to get the users added to a particular group in a particular month. There are chances user will be deleted in some days, so I wanted to see in count per month. Can someone guide me how to ac...
We are fully licensed for PA Premium for Service Management. We have a baseline (or, OOTB) Dashboard in PROD called Incident Premium. We are on Utah release (Patch 8).There are two tabs in this Dashboard that show a date at the top. These are the "Pr...
I guess the highlighted data showing in the dashboard is very high. Pls guide me whether it's actual data or not.
I am trying to build a report for all monthly time sheets that are submitted so we can easily compare them to the monthly report that is sent to us by the contracting company we use. We just implemented the SPM module and are moving people into SN fo...
I am trying to create a heat map report based on Metric Results [asmt_metric_result] to show completed instances in the last 90 days and I am filtering for one metric type of 'IT Incident Survey'.I want it to look something like this (based on incide...
Procuro uma dica de como criar um relatório grafico com 2 variáveis. Exemplo, um unico gráfico mostrando Incidentes Abertos e Incidentes Fechados, por mês.
Hi All,I have a requirement to create a spotlight criteria for the change record. To create a spotlight criteria by checking the data from change and incident table Below are the conditions:Need to check the affected CI in the change record is having...
Hi all, when the content block is loading it initially returns an error message: It subsequently loads correctly, but do we know why the error message is initially displayed and can that be corrected? Thanks
We have a script in ACL that executes when user tries to access the records. This script basically checks whether he is part of a some security zone(custom). ServiceNow recently recommended us to cache this to user session as soon as he logs in inst...
