Hi all, I'm trying to build a report that would show me the top 10CI each month. I succeeded creating a report that shows me the TOP 10 CI on which I can set an interactive filter and select This Month, Last Month, Last 3 month ans so on but that's n...
The OOB metric Assigned to Duration calculates the duration of the assignment in an INC. It also calculates the duration where the assigned to field is empty.in the example the same incident has been unassigned for 2 durations in the life of the tick...
Anyone know what table holds the link of which reports are on which dashboards? I know it's not pa_dashboards or sys_reports... but I haven't found the correct one and the admin console doesn't show the name of the dashboard on the Reports tab. Here'...
It appears that tags are added as applications/modules are added or updated. And those list of tags appear to all users when right-clicking in a list, then selecting Assign Tag > More...When the user selects More, I want to show only those tags the u...
Hi Everyone I am getting Job Error while collecting the data in Platform Analytics. Do anyone have any idea regarding this error message.This is the error message:Unexpected exception occurred: com.glide.sys.TransactionCancelledException: Transaction...
Hi teamI need few reports (see the attached)1. A NUMBER which shows Open Request and Incident2. A NUMBER > Unassigned Request and Incident.3. Average Age Thank you
Dear all, I am working on a report and I want to group by but not with a column or just one factor. Let's say I will use short description, I want split the report to a group with short description that contains Android, another one for the tickets ...
I am looking to create a report that will bring in all of the Change Requests approved underneath of a manager? He runs 11 mnemonics and wants a report of all of the changes approved inside of his "tree."I was adding in all of the mnemonics separatel...
Can we Import Catalog Task and ALM Hardware records from Prod to Dev? If yes How can we do that and are there any related tables to be imported?
Hi! In Multi-level pivot reports and single score reports, one can edit the coloring rules (see eg. https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_DefineAPivotTableColoringRule.html). Is there away to achi...
Good morning, I am new to the community forums and wanted to get some insight on a report I am stuck on. I am creating a report by Bar chart on the Task SLA table to specifically look at the "business elapsed percentage" so we can get a better unders...
Hi All, I updated a flow recently and noticed that older RITM (3 months old) that are being now updated are dropping the older flow and picking up new flow and requesting approval of groups that approved in the past again. Is there a way to prevent t...
Scheduled reports do not sending attachment in the email notification and groups receive the email but miss the attachments. What could be the possible cause and how can we fix this issue? Thanks, Mohammed
We are trying to calculate a general uptime by using the number of minutes in a month minus the downtime. For the uptime formula indicator we were hoping to utilise the function (score_end.getDaysInMonthLocalTime() * 1440), however this does not work...
Hi allPlease, does anyone know why (and how to fix it) is a chart tooltip displaying incorrect week title?The tooltip shows the title of the upcoming week. If I point to the week 44 the tooltip shows the title "W45".Data is correct, the count of days...
