I need to create a trend report of time spent by several assignment groups, resolving tickets.
How would I create a trend report showing time spent by specific assignment groups resolving tickets? Thanks!
Forum Posts
Resolved! Data Collector JOB || PA
Please guide me when we need to use Relative start and end to 0 and in which condition we need to put 1 in Relative start and end,Please guide me as i am new to this forum
Will adding a new breakdown to an existing indicator with existing breakdowns break it?
Hi All,I've been building these PA reports for a few months now and I've been asked to add a new breakdown to existing indicators. I'm wondering if adding a new breakdown to existing indicators with a breakdown matrix will break what's already there,...
Breakdown for a boolean field type referencing a choice source field
Have to create a breakdown for an incident indicator showing whether the incident is of VIP user or not. VIP user in incident table is Boolean field calculated from user table where a user is identifed as VIP basis labels Platinum, gold or silver cat...
Creating a widget of a very large table
Does anyone have any thoughts on how best to create a widget of a very large table (sn_vul_impacted_services), but grouped by Service? So that only counts of the number of records by Service are displayed, and then one can drill down into the counts ...
MTTR Report using Performance Analytics Indicator
Hi All, I have requirement where, we need to show report for MTTR using incident table. I created the report in Classic UI so, below is the one. But, when I created using indicator, it did not give expected results. Report in Classic UI:Filter Condi...
Sync interactive filters between tabs
Hi,I have four tabs in a dashboard, all of them have the same interactive filter. Is it possible to sync these filters so that whatever selection is made on the first tab is automatically synced to all the interactive filters in the other tabs. or is...
Create a MTTR data visualization in Platform Analytics Workspace
Hi All, I have requirement where, we need to show report for MTTR using incident table. I tested this in lower environment and found the similar Indicator which has required conditions. But, when I used that indicator in Workspace, it is not showing ...
How to find missing record in association table
Hi All, Is there a way in Performance Analytics to find the missing record in Association table. We have Table A and Table B and they are linked using Table C. Now we need to know what all records we have in Table A which are not linked with Table B ...
SLA Breakdown Reports in Performance Analytics
We have recently implemented a new Plugin called "SLA Breakdowns" which provides a new tab at the bottom of incidents highlighting the duration the incident has been with various assignment groups and at what point the SLA breached. Rather than analy...
How to add custom dates to Interactive filter
Hello,I have installed the Fiscal calendar plugin and we got new choices like Last Fiscal month, Last fiscal year, This fiscal year, etc.The requirement is to get the same choices in the date filter of the interactive filter of date type. In other co...
No score for Number of new cases
Hi Everyone, When I run the daily/Historical job the automated indicator to collect new cases daily shows zero. Conditions:There is no additional condition for this indicatorTroubleshooting done:The indicator source can collect the value Are there an...
Close Code on Change Request
Hi All, I have a requirement to create a report using Indicators for below existing report filter condition. In my instance, I have the indicator source with below conditions set. The difference between these 2 is only of filter 'State' and 'close co...
Issue with Calculating Average mi_business_duration for Incident Using Custom Schedule in ServiceNow
I'm encountering an issue with a metric definition in ServiceNow and would appreciate any insights or guidance you can provide. What I've Done So Far:I have successfully created a metric definition to measure the average mi_duration for an incident f...
How to show records collected by indicator in analytics hub?
Hello, I'm trying to prepare automated indicator which will count number of problems under specific conditions.The conditions are complex, I had to use a PA script to achieve it (and this works fine), but now I have a problem to show collected record...
