I am building reports using the Resource Aggregate Monthly table and would like to create calculated fields that provide % of Utilization as in green fields below. Today I have to export the data in my Pivot table into excel and create the % fields ...
In the report, I want to compute a percentage using single score , but i got a number only .How can i get the percentage or where can i calculate the percentage of two numbers?
Hi, I have created a scheduled report while executing this it is sent from servicenow but not received in mailbox. While investigating this i found that 'User' field in email log is empty that is why it is not getting triggered in mailbox. How can i...
Hello, Is there a way to copy/clone a PA widget in it's entirety? Insert and Stay copies the widget, but not with the indicators attached. Looking for something like 'Insert and Stay with Relations' that Automated Indicators have. Reason:Setting up S...
Does anyone know if there is a list available of the out of box indicators for the PA CMDB Content Pack? We have not yet enabled this but would like to see a list of indicators that are part of this.thank you!
Hi Everyone, I'm currently trying to remove duplicate and redundant versions of global reports created by previous administrators and ex-staff to simplify the environment. Basically, I need to determine which reports are actively being utilised or a...
Hello, I am using task table for the Interactive Filter and for the report on Dashboard i am using task_sla table. So when I am applying the filter, it is not filtering properly. Please let me know the solution.
I have a user with pa_viewer and pa_contributer roles. They are member of a group that the dashboard is shared with yet they cannot see the dashboard drop-down. Any ideas? See pic.
Hey there,i have a report using a data set. The initial report was ok (i think) with 2 lines in one chart - but now the 2nd data set is missing on a TEST instance (hence the report only showing 1 of 2 lines) but i cannot get it there again by moving ...
Hi all, I'm trying to create a report on active problems where all the problem tasks are closed but i think i'm over thinking it. The purpose of this report is to pick out stale problem records which are active but have no open tasks. I was able to c...
how to extract MTTD and MTTR in Servicenow
I am looking for a way to generate a report of all active users with roles and recent activity - the ideal way to do this would be a report against the sys_user table with the following criteria:Active is TrueRoles is anythingLast login on This yearU...
I created a report on the incident table and under share setting selected "everyone". We would like a handful of non-itil users to be able to access this report. In order to accomplish this I created a new roll called CRMReport and added it to the in...
We have a (Reporting) Pie-chart with data labels which are relatively long. The data labels were being truncated but we were able to fix it by modifying the values in Reports > Administration > Properties. However, when we try to download a capture o...
I would like advice on how to write a formula indicator with an if statement. The scenario is If today is Monday, True would be sum incidents opened Friday, Saturday and Sunday / incidents opened on Thursday, False = sum of incidents opened yesterday...
