I've been tasked to create a heat map that will show assignment groups for rows and Month closed for Columns. The aggregation is the average Resolve time. The issue is that I cannot Group by Month so the report has dates and time along the X axis. ...
I need to have a chart for my team's velocity that shows committed and completed by sprint. Heck I will even take just completed to make it easier. I would like to see a trend (so sprint over sprint over time) and see the number so I can see what the...
Hi Team, Currently we are looking for an functionality where we should able to calculate duration taken by an particular assignment group (ABC group) to close that particular case (duration taken from case assigned to ABC group till case gets closed)...
Assistance creating a database view between the Interaction and Metric Result tables. My objective to report on survey's that have been completed with Live Agent (Human) engagements and then engagements that have occured purely within a Virtual Agen...
I'm looking to report on which workflows use a specific group for group approval. I've seen posts to find this for open records but I need to see the workflows that would generate approvals. I think I'm looking at the wf_activity table but can't find...
Hello Experts! I need help with Count Distinct on a report. I have a indicator on [asmt_metric_result] table and I am trying to use the Count Distinct on the Instance field but it doesn't seem to be working. I tried with basic reporting and for each ...
I'm working on building some pivot tables and need the ability to hide the Column Total.The reason being that the breakdown of the items (rows) are generating values which are averages. These averages are correct.The pivot table is then combining th...
Hello In a workspace we have a Line graph which shows 2 values, one being surveys sent out and the other being surveys completed, both being over a 6 month period, grouped by each month. I have now gotten the request to also display percentages of th...
Hi experts, I'm using a vertical Bar graph report. In that I'm grouping on a column with aggregation set to "Count". This does the work but I was wondering if I could narrow down the list by having a condition that shows data only if count value is g...
Hi, I have requirement to create new metric to calculate if Cases are handled in 15 minutes. I have read about the metrics, this would seem relatively easy, but we have requirement that metric should be calculated during our business hours between 8:...
I wanted to created a New Breakdown in Performance Analytics for the Incident table.After setting it and trying to collect the data I received this warning in the Job Log ¨No/Invalid breakdown mapping found for breakdown Service.Taxonomy node and fac...
Hey guys!Is there a way to bring only one ANS definition per call?In some calls I have the OLA type, in other calls I have the ANS type. In other calls, I have the OLA type and the ANS type. I would like the calls not to be repeated.So, instead of re...
My requirement is to create a dynamic interactive filter that allows users to to filter reports and dashboards by fiscal quarter, months or years from the fiscal_period table. I have a script include which builds an object with the relevant informati...
Hello everyone, I'm trying to create a simple report from the cmdb_sam_sw_install table by adding a condition from the Installed ON related fields so that only Linux Operating systems machines return the volume of Software installations per OS. Howe...
Within my org we want to report on the department data held within ServiceNow and I want to create a report which shows departments which are empty OR have ONLY inactive users in them (not active and inactive). Can anyone assist with how this report ...
