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...
Hi Everyone, I am trying to create a report to answer a question about productivity, however I can't seem to find a way to calculate the answer. I'm hoping that someone has run across this issue before. We are currently using Madrid. Objective: C...
We have upgraded to ITSM Pro which includes and upgrade to PA. It is not clear which of the multiple plugins apply to ITSM Pro. I have looked at the subscription set to see what products are included and it is not clear there either. ITSM Pro inclu...
I've set up a report trying to replicate something that is currently being completed manually in Excel. It is a standard multi-level pivot run from the Time Card table, with the following choices: However the columns I am sorting by are displaying o...
Hi, i want to glide query within SNOW to find a field that contains X but exclude the last 3 characters EG Field_Name Fred123O909 BOB123O857 Jim475O123 Jones589O909 i can only use the number '123' and I want to return Fred and Bob only. My query at...
I'm looking to create a dashboard to display the availability scores for our critical applications. I was thinking I would create a series of indicators and formulas to calculate the availability percentage for the month, year to date and hours/minu...
I am setting up reports on users for a dashboard and i have asked if i could put in an interactive filter in for the user manager. I thought this would be a simple reference Interactive filter but it doesnt allow me to create it. The idea is i select...
I am creating a dashboard and I have been requested to provide a percentage figure (for time spent over all time) by a Catalog Variable called "Request Type". I am presently using u_catalog_variable which appears to contain the data needed. For Exam...
Anyone have any idea that why this error comes? Type pkcs12_key_store is NOT supported!: no thrown error. Your response will be highly appreciated . Thanks in advance !!
I've updated a PA Dashboard and everything is being presented in French, when French is selected. The challenge that I am having is that the PA Dashboard drop down list is displaying all of the available dashboards in English when French is chosen. ...
Hi, I created a few dashboards for a customer with lots of reports, and now the customer is asking to disable the drilldown to the list of records of the report when you click it. I saw a documentation on how to do this (https://docs.servicenow.com...
I created a (true/false) column named u_requires_clearance in the core_company table . I then created an interactive filter "Require Clearance" I added the filter to the dashboard but it is not filtering the list of tickets based on this filt...
I have a widget with three formula indicators displayed inside. All three of these have targets applied to them, but only two of them show the color scheme for that target. All three formula indicators display data, and all three show the target in t...
Are you able to group multiple assignment groups together in Performance Analytics? Scenario: A Director support 3 out 25 assignment groups. He would like a report that combine all 3 assignment groups as a whole, but also would like a breakdown of ea...
What does it really mean to publish a reporting url or dashboard url. Is there a way to publish it so the user does NOT have to log into ServiceNow? We've been asked to do this by our Leadership team and I would like to know how to accomplish this wi...
