How to report on Total number of days in a month using an Automated Indicator
Hi Everyone, I want to fetch total number of days in each month using an automated indicator.Example : January - 31Feb - 29March - 31
Forum Posts
Visualization of Daily Tagged Incident Records by Assignment Group Type
Hi, friends. I've been scratching my head on how to achieve this in Performance Analytics:I need a breakdown by Group Type in ServiceNow. My indicator is a tag (in the label_entry table), which is assigned to certain incident records by a user.Essent...
Create dashboard widget with combination of multiple table(data source) using some certain queries
Hi Everyone, I am looking for help to create dashboard widget with combination of multiple table(data source) and some certain query to filter out the data like Risk Score = (Incident Count × 1.5) + (Critical Alerts × 2.0) + ((100 - Availability %) ×...
Resolved! Platform Analytics - Access rights
Hello, I have a new dashboard in Platform Analytics. I shared it with a team for read view, and at the same time with one member of this team, in a Write view. Which right will be applied: Read or Write? Best regards
Resolved! Solution for reporting Parent changes that shows related child changes and Incident records.
I am looking for help creating a report on Parent changes that shows related child changes and related incident records. I attempted this with a DB view combining the tables but its confusing and doesn't seem to provide all the data as expected. Does...
Group by in Automated Indicator
Hi - I have created an automated indicator that pulls the records from SLA Breakdown by Assignment group table to measure the Incident SLAs for my supplier. This table has records for all the assignment groups but the breached column is set based on ...
Workspace dashboard simple arithmetic
As part of a dashboard data visualization element, I would like to plot the average of the difference between two fields in a record (i.e. `AVG(table.fieldB - table.fieldA)`) but have struggled to find something that doesn't seem overly complicated f...
Performance Analytics Dashboard Preferred Language
Hey Team, New Dashboard was created. 1st Version was captured with 2 Visualizations True and False. (English) Saved and Exit editing mode. Confirmed in Spanish (or preferred Language) and Visualization appear in Spanish 2nd Version add a Simple Li...
Performance analytics application availability
Hi Team, I have a requirement to fetch the application availability for Criticality 1,2,3 applications. We need reports to show availability in percentage and in Mins. I have created indicators and breakdowns accordingly based on data in cmdb_ci_outa...
Which Automated Indicator and data collection job are used for widget
In the Request Management Overview dashboard, there is a widget called Mean time to fulfill a requested item (by category) I need to know:Which Automated Indicator is used for this widget?Which data collection job runs to populate this indicator?How ...
Can we add two breakdowns elements?
Hi all,I was wondering if we can sum up the value of two breakdown elements. I have a very specific case which I'm hoping you can help me out. A bit of background: On the incident table we have the OOB Company field, however previous admin created a ...
Applying a date range on a Pivot table
Hi! Is it possible to apply a date range filter on a pivot table data visualization?I have a client that wants to be able to see weekly scores for one of their indicators on a pivot table, and then be able to use the date filter to see scores for wh...
Reports
For a service catalog item, I have several workflow steps. After each step is approved, the item is sent to a new assignment group.I am looking for a solution to create a report that would display the time an item has remained in “Pending” status for...
Performance and Platform Analytics On-Click Behavior
Hello, I am trying to configure the On-Click behavior in a Performance Analytics report (Pivot table of Database view) to redirect users to the Source table with the data filtered based on where (what cell) they clicked in the report? I'm actually us...
Migration to Platform Analytics - homepage not loading after migrating
Dear community, we are experiencing issues after migrating our core dashboards that are usually part of people's homepage.After migrating to the new Platofrm Analytics, we just get a blank page and the homepage is not loading. You have to basically c...
