I'd like to create a pivot table that only has a column for Assignment Group and one column for the Total number of Tasks assigned to each group. It seems that ServiceNow requires to divide the columns with at least one additional field. Is there a w...
I've created a dashboard that includes 3 reports and an interactive filter. The interactive filter uses the company table to filter all three reports. The filter works for itil users but not for business_stakeholders. When I impersonate a business...
Good Day everyone, Thank you in advance for your help. As part of an application I am building, I need to be able to create reports and dashboards automatically once a user fills in a form with the necessary information. Is this possible, are there...
Is there a way to make it so that reports that have not been run in over a year cannot be executed? In addition, on the page of a report that has been disabled this way, would it be possible to display a message saying "this report has been disabled ...
What is the difference between Performance Analytics and Performance Analytics Premium ? What I can do in PA premium that I cannot do in PA ? Thank you Regards,
Greetings All, I have a question about the definition of Last 3 Months in reporting. I often will create reports that use Resolved Date On This Year/Last Month/This Month, etc. What I found when I used Last 3 Months however, is that t...
I'm trying to create a view where I can see tasks for demand and tasks for the project table. I works fine when using on only a joint view between the demand task , demand and project table. But, when I try adding the project task table to the equati...
Hi all, I need to create a pie chart, based on Knowledge Articles (table kb_knowledge) that are in the Draft workflow. Some of these KAs have been created based on an incident, others are created from scratch. If a KA is created based on an incident,...
Hi all Keen to hear about any best practice approaches out there when it comes to managing sysevent volumes. When there are too many events being processed typically caused by a rouge source generating and queuing too many events, this can seriously ...
I have a cascading filter that doesn't seem to be working. I'm not sure if I misconfigured it or if something isn't working as it should. Is this configured correctly? I create a report using the same query using the same query sys_id but wh...
I need/want to use the coalesce function to consolidate data fields from the Demand, Project, and Program fields in order to report on allocated and actual time. The three tables are used in a database view along with resource aggregate monthly, and ...
Hello, We have a request to add count trend line to a existing column graph, which will help compare average outage time vs. monthly outage count (see pictures below). unfortunately, I have not been able to locate a solution to successfully accompli...
Hello, I am trying to create a report that shows average Tickets per user per month and looking for some inputs on how show. If not average month on month active users count and number of tickets raised in that month, how to combine and show it toget...
I created an interactive filter on the sys_user_group table which loads up all of the groups that a given user manages as well as the groups of the managers under them. This is accomplished by calling a script include in the interactive filter. Essen...
We want to see all the incidents transferred history to any group in a report.for example, If an ABC ticket is created and it is assigned to suppose A group and then again it is transferred to B group..I want to all these in a report.Can anyone help ...
