Resolved! Report - How to add multiple values when using 'does not contain'
Can you add multiple values (~24,700 numbers), when using 'does not contain'?
Forum Posts
Filter incidents by problem tag
I want to be able to visualise the number of incidents related to specific problem records over time, the problem records are identified by a tag. I start my query in the Incident table and I want to be able to specify a filter on "Problem.Tags has I...
Reporting: Is there a list of tables most commonly used in reports for INC, CHG, REQ, and what they include?
For reporting on Incident, Change and Request, there are a group of standard tables we use repeatedly (listed below). Does anyone know of a summary of these common tables that describes when to use one over the other based on the data you are target...
Where is the CSAT score stored?
I would like to know if the CSAT score reflected in the Customer Service Executive dashboard is stored in a table? If not, how can I have access to the CSAT score overall? I want to use it for my Alexa integration.
Resolved! WARNING: Invalid order by field "u_ist_priority": You can only order by the "Group By" field and/or the "Stacked" field
INSTANCE: London, on the latest patches "Invalid order by field . . . 'u_ist_priority' is not referenced. Why am I still seeing this Warning message?
Comparison Reports
Hi there - Does anyone know if I can deploy two distinct reports in a side-by-side arrangement, where one report would show Assigned to (Joe User) and SLA MET vs MISSED counts, and the other report (positioned to the right) would show Assigned to (J...
Resolved! Reporting on User Assets
I am trying to create a report form the sys_user table that shows the users name Department, and what assets are assigned to them. I was able to pull first name, last name, and department. The assets are in a related list though. How do I add that to...
PA - Open SCTASKs - Average Age, Average Age Since Update
Hi all, I'm currently overseeing a programme to analyse how well our suppliers are fulfilling tasks as we are aware that a disproportionately high number are remaining open for a considerable period of time, and this needs to be managed down. My curr...
Dashboard breakdowns inside each tabs and multiple selection of elements from breakdowns
Hi All, I have created a PA dashboards with multiple tabs. Each tab is different from one another. Currently the dashboard breakdowns are outside the tabs and acting as a common filter for all tabs. 1) Is there any possibility to bring breakdown ins...
Should I be able to create a report on pa_scores_l1?
Our leaders use Apptio to perform monthly reviews of the overall health of IT, but a lot of our best data lives in ServiceNow - specifically in Performance Analytics. Apptio connects to ServiceNow and can pull over specific reports or tables (as lon...
Resolved! Report to show difference in trend WITHOUT PA
Hi everyone, I'm wondering if it is possible to produce a report that indicates the difference (positive or negative) from a trend, My organisation doesn't have Performance Analytics so I'm hoping there is another way to produce this. At the moment...
Resolved! Performance Analytics licensing
Do consumers of visualizations created in Performance Analytics (PA) need PA licenses themselves? Or, are PA licenses only needed for creators of these visualizations in PA? For example, if I (a creator in PA) created a set of scorecards in PA, cre...
Tracking SLAs by Assignment Group
Preface: I am looking to track SLA breaches and pinpoint which Assignment Group is responsible. Testing in Dev, it seems in my instance that every time an incident is unassigned, a response SLA begins (and conversely stopped when assigned). However, ...
Resolved! How to assign different colors in Donut charts based on Values in SNOW Dashboards (PA/Reporting)
Hello, Can anyone advice how to achieve the different colors in Donut chart based on values. Example : if value is 10 - color need as RED, if 90 above color should be GREEN find below screen, for any value color is defaut GREEN based on value want to...
Averages on a Formula Indicator
I recently had a question come up from one of my customers, and it seemed like it could be a bit tricky, so I thought I'd put it out here for consideration as well.They were looking at the "Average Time to Resolve an Incident" indicator - when they c...
