Hi everyone We have SLA's set at the RITM level but assignment group and assigned to are at the Task level. I need to provide a way for users to pull reports on the SLA stats filtered by assignment group and assigned to. There is not OOTB database v...
Hi everyone, The PDF file generated by Scheduled Email Report is not attaching to the top section where all the attachments are. However, the email is sent out without problems with the PDF attachment. Anyone know why this may happen? Any help will ...
Hi everyone, I am trying to report on how many times an incident has been bounced around between assignment groups. I can get the information and happily export it into excel to create a meaningful pivot.However, where would be the fun in that. I am ...
I would like to create a report for each technician showing them the number of tickets they have resolved, compared to their team's total and the average for a technician on their team per month. I'm stumped on how to do the average. I know how to do...
Hello SN Community... Looking to find out how to create a report for Problem and Problem Task tickets closed by due date? Is this possible? We have been working through the filtering options but unable to figure it out... Regards, Will
I'm having trouble creating a report that details incidents by day (or date) since a particular time. Example: I need to run a report showing all "email" related incidents since 10/15/2019 @ 5:00 AM. In the attached screenshots, you can see exactly w...
Hello experts, We were recently given a requirement to capture a list of project statuses. However, the client only wants the most recent status for each project. I know that count distinct would bring this down to only one, but how can I configu...
When you create a Score in reporting, is there a way to customize the global layout/fields of the drill through list view? I can update it for me but I don't want the users having to update the drill thru view every time they drill into a score. I ...
Good day everyone, We are trying to export a report from a dashboard. While doing so, some of the columns are missing from in the excel file exported. Does anyone know why this is happening ? Thanks Kevin
How do I remove display grid and scroll bar from the PA Widget? Snap shot attached for the reference.
How do you recommend creating dashboards? We have a dashboard and reporting service that we provide to our customers. We have responsive dashboards enabled (restricted - not all users can create a dashboard, dashboard owners can only add reports and ...
Hi, experts. We are watching in production several users complaining of issues with the single score reports when the conditions include OR Conditions. For example take the reports on devageaspt: "Issue on Sum on GlideAggregate" and "Issue on Sum on ...
Does anyone know if it's possible to use Document ID fields in joins on Database Views? (I know that Doc IDs behave differently to Reference fields) I'm trying to join the sys_update_xml table (cu) to sys_update_version table (ver) WHERE cu_sys_id =...
Hello, In the reporting module when we specify the date filter as "this week" or "next week" is servicenow always looking from Monday to Sunday as a week? Is it following the international standard ISO 8601, Monday is the first day of the week. It i...
I'm still learning PA, so bear with me. Right now I'm trying to create a metric that shows % of X. I've set up automatic indicators for the numerator and denominator of X, then a formula indicator to calculate the %. I need to show the monthly % on a...
