What formula will average the duration of all tickets opened by in a month?I tried using the followingHere's a step-by-step guide:Indicator Source:Go to "All" menu > "Performance Analytics" > "Sources" > "Indicator Sources" . Click "New": to create a...
Hi,I'm trying to calculate the SLA Duration for an indicator using a pa_scripts like below,For eg: On 3rd April 2025,1 day SLA will be calculated like sc_task which are created on 2nd April >5pm till 3rd April <5pm2 day SLA will be calculated like s...
Hi, I want to create a dashboard with Ticket Type filter and it should be dropdown with Incident, Request etc. I am trying to using through the Platform Analytics. Kindly suggest me on below how to achieve this
So its been sometime since I built out a SNOW dashboard but I recall you could do widgets that had content blocks. I found a old link with the information I use to know but when I go into dashboards and try and build, I dont see widgets or many optio...
I'd like to create a report and send it on a schedule. How can I add a dynamic date in the email's subject and the Excel file name?For example, if today is 3/6/2025, I want the report to include data from 3/1/2025 to 3/6/2025. The email subject shou...
I want to show duplicate server name along with count in cmdb_ci_server table using performance analytics. Can anyone help me on this to achieve. Thanks
Hello,I am getting 'Nan' error for a script (pa_scripts). I have written this script to exclude weekends and holidays and added as a breakdown through breakdown mapping in indicator.Please let me know why I am getting below error and whether I am go...
Hi All, I'm new with PA indicators. I need to recalculate the historical value from a table that contains a start date and a cost. As an example: RECORD 1: start date: 1/1/2025 - cost $100 RECORD 2: start_date 1/2/2025 - cost $100 I configured the ...
I currently have a unique issue I'm facing and would like some guidance if the resolution is even obtainable.For our groups (sys_user_group) today we use a custom field called "Display Name (u_display_name)". This field is used for various reasons du...
Hi All, I reached out to ServiceNow Support but seems my question got lost in translation. I was wondering if anyone has been able to set the date format on filter widgets in PA to match that of the system. Our back end is set to Europe, but I can't ...
I am manually checking the quality of the Incident, Change, Service request tickets to know how the ticket has been handled. This manual activity is time consuming, we have a set of parameters on what to check in a ticket, any way we can automate thi...
Hello - We just migrated our dashboards in Performance Analytics to the Next Experience. One of the dashboards that didn't update fully out of the box was the Subscription Overview Dashboard. There is an "Update Allocation Totals" button that is a wi...
Anyone having issues with the search bar?
Hi , I'm getting this error: ERROR: "Cannot generate the report. Missing parameter trend_interval for series 0" when I try to create a simple report "Open Incidents by Created Date" using the Trend type report. What am I missing?Thanks!Suzanne
Hello I saw that it's possible to export and schedule Platform Analytics Dashboards. Export a Platform Analytics dashboardIn my configuration I do not have these options. What could be the problem? Any additional plugin to install?
