Reaching out today as we’re currently stuck on trying to create a performance analytic report for our technology leadership. Exactly as it sounds, I want to create a PA report which shows the availability of the CI from the outage table in % format (...
I am trying to create a stacked bar chart that shows a count of configuration items over a period of time that looks something like this:From what I understand, this cannot be done with reporting tools and must be done with Performance Analytics.I ha...
Hi All, I created a very simple report on sc_task listing new tasks since 01-JUN-2022, and visualized as a bar time series. The colour I used for the bars was “UI14 Green”. In the Dark Mode Theme, I ran the report and the bar colour that appeared loo...
Hello,I am trying to build a report which shows the requested items and incidents closed by a specific department in each of the past 10 days. I am using the "Trend" report type, grouping by "Closed" and Trend by "Closed". Please see the attached ima...
Is there an easy way to capture the approval times? We're wanting to see how long it's taking our approvers to approve their request. We don't have metrics setup at this time and I believe we can accomplish this using PA but it looks like that ma...
Hi All, Having a real problem with this one.As the subject suggests, I would like to report in ServiceNow, on catalog tasks (sc_task) where the assignment group is not one of mine. In other words where the user of the report runs the report, and can ...
Performance Analytics formula indicator not handling NULL very well Lets assume we have 2 automated indicators : numProbSLAdue => collects the count of problems for which the SLA is due to expire today,numProbSLAmet => collects the count of problems ...
Hello community, I was asked if I can create a report for active incidents where the child ci does not have support group. We have a process where we receive some automated incidents; the service desk will open the ci record in cmdb, scroll down to t...
Hey All,We have a requirement to get the interactive filter default value when the dashboard loads. Is it possible to set the interactive filter value externally? ThanksSurya
As a admin, I created a visual task board with rm_story table. In Visual task board the columns appear with state choices (Draft, In-Progress, Complete etc..,). I wanted to remove few lanes in the board. Initially I hided the lane by using the option...
I am looking to create an interactive filter for assignment group as well as incident ticket numberoff the metrics_instance table. Can anyone tell me what the reference table needs to be as well as theinteractive filter reference table in order to cr...
Hi all,In AWA Operation Dashboard under Queue Manager tab Agent Presence &Capacity report is shared with the user having awa_agent role.the report is showing Security constraints prevent access to requested page even the shared with awa_agent role us...
I want to create a report or indicator showing average duration ticket is sitting in certain states. I was able to get to this fairly easily in reporting to start. Although, I always find the need to specify a column annoying. Is there another way to...
We have recently deployed Performance Analytics in San Diego and have encountered a number of issues with regards to the OOTB dashboards which came from the ITSM and additional content packs. The plugins were activated last night, the historic data c...
I would like to create a report to show template usage. We currently have 3 templates that we use. [the names are contract closure, project support and forecast variance.] The table I am referencing is template [sys_template]. However, I do not k...