I have a widget with three formula indicators displayed inside. All three of these have targets applied to them, but only two of them show the color scheme for that target. All three formula indicators display data, and all three show the target in t...
Are you able to group multiple assignment groups together in Performance Analytics? Scenario: A Director support 3 out 25 assignment groups. He would like a report that combine all 3 assignment groups as a whole, but also would like a breakdown of ea...
What does it really mean to publish a reporting url or dashboard url. Is there a way to publish it so the user does NOT have to log into ServiceNow? We've been asked to do this by our Leadership team and I would like to know how to accomplish this wi...
Hi all, I am currently developing a dashboard which focuses analysis on Open Incidents for one of our suppliers, and I am now in the process of building-out a number of the Breakdowns to support it. The reporting requirement is calling for Breakdown...
Hi team, I need to create a custom report on Incident table. The criteria is: I want the time spent of incident in each group. i.e. If a incident is first assigned to service Desk Team and then to Database Team and then to Hardware Team. I need to cr...
I need to created a breakdown for a catalog item variable. Need help as the data is not showing up in the breakdown. I am new to PA advance reporting. I have a variable name as "Server Name" referring to cmdb_win_server the requirement is for cre...
I have a requirement to calculate the Avg age % open incidents in Days. Have applied the below formula OOB we have formula "Summed age open incidents / Number of open incidents / 24 hours" to calculate Average age open incidents . Let me ...
Hi all, I need to generate and send by e-mail a daily report in "English" ( the instance have system localization = it ), So, I have tried to modify the Scheduled Email of Report, specifying in the filed run as a user that has language = English, bu...
Hi all, I want to share a dashboard with all the company in our Sharepoint site of the company. I need to embed the dashboard content within a Sharepoint page. Is it possible? How can I do it? I look forward for your reply. Thanks in advance. BR
We are looking track and report on the usage of an SLA per assigned to user as an incident is transferred. We are having trouble configuring. Has anyone tried using this functionality in PA? If so, what have your results been. SLA Breakdown Definitio...
What is the syntax to concatenate two fields in a Database View Where clause? I need a variable and a text string to form one side of the Join comparison. Example Where clause: sysuser_email = abc_variable_field + "@test.com". I know this is not the...
New management came into the job and they wanted to see how incident, request, and change resolution time has changed. First ticket update all the way to closed before say like before 3 months ago and how it has changed from 3 months ago moving forw...
Hi, Need to schedule a report which is triggered only when the row count of the report is more than 3. The report is saved in SNOW on incident table with some filters on it. Please help. Thanks
Hello guys, I'm running a report of the incidents and would like to be able to pull whether the incidents have an attachment or not. A count of attachments would suffice. Is there any field that pulls this from the table 'Incidents'? Thanks,
Hi , I am working on a formula indicator to calculate percentage of SLA breached. The approach I am following is: 1. Created indicator source (which gets data from SLA table) 2.Created automated indicators : SLA breached and total resolved incidents....