Average Incidents backlog per day
How to calculate Average incident Backlog per day? Any help will be appreciated.
Forum Posts
How to get tags on the incident sla table
Hi Team, When i tried to pull the report on the incident_sla table, unable to see the tags. But on the incident table, able to see the tags on the report. How to get tags on the incident_sla table.
Report to show all Approvals on changes, but only on changes that a Specific Group are an approver
Hi, Is it possible to create a report, where the criteria is that it will show all approvals for all change records that a specific approval group are approvers on? So - change record has an approver group "APPROVER-A" on it. The report criteria wo...
Resolved! Interactive Filter - Reference in List
I'd like to create a reference interactive filter that allows multiple selections. I need it to filter on a list, field, though. Is this possible? For example, I have a list report of records that have a field referencing the department. A record may...
Resolved! Report time worked in hours and minutes
I am building reports to show total time worked on tasks. I am pulling from the Time Worked [task_time_worked] table. Filters set to only show tasks that were updated this week, task type is Incident (I have other reports for other task types). My...
Hide certain topics in "Show me everything" in Virtual Agent
Hi, is it possible to hide certain topics in "Show me everything" button in Virtual Agent, but not touching the "Is visible" property in the topics table?
Resolved! SLA Report for specific Assignment Groups under Incidents, Service Catalog and Problem tickets
I would like to create 3 reports for Incidents, Service Requests(SCTASK) and Problem tickets. Eg: I need to show the number of SCTASK items which missed the SLA for my set of assignment groups(approx 10). I'm not able to add the assignment group as t...
Resolved! Export report shows sys_id instead of display name
Hello Experts I created a report on RITM table and dot walked to Variables[+] and included the required variables in my report. Now when I trying to export this report to CSV/Excel the report header shows as variable.sys_id. Is this a known error/exp...
Sending Reports in the mail body
I have created a Report and my requirement is to schedule that report and send as a mail to users. I was able to send as an attachment, but my requirement is to send that report content in the email body as a screenshot or it can be of anything. But ...
A report of top 5 Incidents
I have create a monthly Incident report which is grouped by Reference 1 field, and the report shows the count of "category data" in Reference 1 field. For each month I only want to show top 5 count. Is it possible without using scripts?
Resolved! Issue with list field (multi-select) reporting
Hello Everyone, I am trying to create a report on one of the table and am trying to group by 'list field'. This option is not available, since the list field(multi-select) might contain more than one option. However, when I click the additional grou...
How do I export the breakdown data of a scorecard in performance analytics
I am Looking for a solution to Export the breakdown data of a scorecard. See example below. When I click "Export scores to CSV" I just get the overall score, but not the detailed list below. So this means I have to copy manually each value from the l...
Resolved! Show Last 30 days running sum as Monthly score
Hello, Based on the sys_ui_navigator_history table, We have an indicator that shows the dashboard view count for a particular dashboard. The indicator source is set to Daily frequency and the Indicator Aggregate is set to Count Distinct (on 'create...
SC Catalog Variables Interactive Filters on Dashboard
Hi All, Can you please help me to understand if we can create an interactive filter using SC Catalog variables. i tried using normal interactive filter, bu it doesnt give option to map with variables. If you have done any, please share the steps ,...
Hide or Collapse Edit report module
When creating a report in the Classic UI, is there a way to hide or collapse the Edit Report module on the left side of the screen to see the report in a larger view.
