I'm looking to create a chronic report for our 2 groups.What I'm looking for is Configuration Items that had 3 or more incidents created in the past 30 days.I can get the below result, but i don't care about the 1s and 2s and there's no way that i ...
A tab has disappeared from one of my dashboard. It is "blank" now.after investigation, I decided to I deleted it, then recreated it. Then I add the widgets to it. It all looked good for a few seconds but then, blank again.No matter what I do, it keep...
I have a score car widget that show "No data to display". That widget uses the same formula from a breakdown widget and it displaysthe data collected on a daily frequency. NOTE: they both use the same formula.Formula: ((SLA Met)/(SLA Breach + SLA MET...
Hi All,I am trying to build a report where I am looking for those values which is not available on some other table.In my RITM table, I have a custom string field where input are given, so it could be anything, including random string. There are so...
Hi,I want to know if there is any way to have the amount of tickets received during a period of time like 8 am to 5 pm. On the other hand based on the same report filter only the tickets where was assigned for the first time to a respective group. Th...
I need the where clause with 2 conditions :1- tsk_opened_at >= DATE('2017-01-01') but nothing happend.....2- (tsk_sys_class_name ='request' || tsk_sys_class_name ='incident' || tsk_sys_class_name ='catalog task' || tsk_sys_class_name ='ext...
We have a Dashboard which reports on both Incidents and SR's. We want to have a date filter that will apply to all widgets on the page. There are 4 widgets. 2 Incident and 2 against the Service Catalog.When creating a new interactive filter it asks y...
Does anyone have any suggestions/best practices for creating a Red/Yellow/Green stoplight-like widget using PA (or base Reporting) for display on a dashboard? We have a portfolio which contains several programs, each of which has an Overall Status (R...
I have been building PA dashboards for senior since early this year and have been creating most of the indicators we want. There is one request form I want to create an indicator in which the "variable field1" contains a push down list of categories ...
Is it possible to create report on the audit history of a set of records (i.e. a portfolio and all projects, milestones etc. belonging to the portfolio)?Basically I need an aggregation of History [sys_history_line] items for a collection of records, ...
The totals of the POs are based on created date, but add together day over day.I have a report based on created date but the ask is to see the line continuing to increase over the life of the project - basic math, day one = $5.00, day two =$5 so the ...
I am sure this has a solution but as of now I cannot find one. I am trying to build a bar chart report showing count of incidents resolved in the past 30 days / 7 days/ 1 day for every technican. Ideally the report would become interactive with the a...
Has anyone used (and has examples) analytics to preform ServiceNow license management? Maybe a dashboard, that shows what is owned, what is in use, users with roles that have not logged in, in over 90 days?I am trying to get out of using reports, the...
When our Service Desk Manager attempts to download a pdf of a customised Service Desk stats dashboard I made for him, some reports in the downloaded PDF have not 'completed' and show as 'loading report', despite the report actually being loaded in th...
We have a custom attribute, Committed SLA (u_eta), which is a date field type. We want to create a report that shows incidents where u_eta > closed.Closed is a date/time field, so it does not appear as an option to compare to the date (only) field,...