Custom Report
Discussion List
-
Custom report for agent productivity using Agent Transactions and Incident SourceSummary: Hi, I have been tasked with creating the below report. The theory behind it is as follows: Scope: CS teams Productivity per person is shown based on actual cont… -
count multiple customer replies in a rowSummary: I am trying to make a report column that displays the LATEST count of customer replies. Content (required): The aim of the report column is to see if incidents …
-
Display top 5 threads associated with each Incident in a custom reportSummary: We have created a custom report to display the Incidents and their threads in a custom report. Each incident can be associated with multiple threads. Hence, we …Chethana KM-139188 11 views 3 comments 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Is it possible to add the Agent Browser User Interface Account Authentication field to a report?Summary: Is it possible to add the Agent Browser User Interface Account Authentication field to a report? Content (please ensure you mask any confidential information): … -
Combining Conditions for column definition expression in Analytics ReportI'm facing a challenge in Analytics reports while trying to create a column definition expression that combines multiple conditions. I have two distinct expressions for …jaliya sampath 51 views 2 comments 0 points Most recent by jaliya sampath Reporting & Analytics for B2C Service
-
Is there a way to undo changes within reports?Summary: Is there a way to undo changes within reports? Content (please ensure you mask any confidential information): I'm wondering if there is a way to undo the most r…kerry walker 21 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Data Model stuck and need to rerunSummary: We have a report that generated only the deleted record but for the new and changed record it was not included in the file. However when I rerun the data model …Cristelle Rose Sampang 1 view 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for B2C Service
-
Report Incident Grouping by Servicing TimeHi all. I have a report that groups incident by servicing time (using the inc_performance table and appropriate interval type filter). Using the formula if(inc_performan…Lucas Zuzarte 31 views 4 comments 0 points Most recent by Lucas Zuzarte Reporting & Analytics for B2C Service
-
Help with report chartsSummary: Looking for help utilizing charts in a report Content (please ensure you mask any confidential information): I'm wondering if anyone can point me to a video tut…kerry walker 11 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Are there any report to extract knowledge advance article ?Hi There, I am wondering if there are any reports that I can use to extract knowledge advanced articles created by all authors. I try to look through all the tables in t…Vincent Lin 61 views 5 comments 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Report to show queues with no agents assigned?Summary: We have a BOATLOAD of queues to manage. Looking for a report to flag any queues that have no agents assigned to them. This would exclude agents disabled in the …Joe P. 11 views 1 comment 0 points Most recent by Makarand Malandkar Reporting & Analytics for B2C Service -
Can we change report standard date format using date_formatSummary: Hi We are trying to change the standard way of displaying date i.e. 09/26/2023 10:27 AM EDT in the report analytics the same way we have in CP or in Connect Obj…Baljeet Singh-231094 31 views 3 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service -
CSAT score report - giving score, comments and agentSummary:I need very quickly to provide a CSAT survey report that can show the surveys answered within a certain timeframe Content (please ensure you mask any confidentia…Howard Williams 11 views 2 comments 0 points Most recent by Howard Williams Reporting & Analytics for B2C Service
-
Add values from two aggregate columsSummary: In a report where two columns are [Total B] = sum_distinct(B.score, by A.ID) and [Total C] = sum_distinct(C.score, A.ID), how do I create a third column that ho…Scott Heidenreich 22 views 2 comments 0 points Most recent by Scott Heidenreich Reporting & Analytics for B2C Service -
Analysis with link to attachmentsSummary: Download attachments from an analysis Content (required): Hello, the customer required to have the possibility in a pre existent analysis regarding SRs to downl…carolagalloni 11 views 4 comments 0 points Most recent by carolagalloni Reporting & Analytics for B2C Service -
Moving ReportsSummary: Are there any negative affects to reorganizing the folders in reports explorer? Content (required): Are there any negative affects to reorganizing the folders i…kerry walker 21 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Report RequirmentHi Experts, We just had a report requirement to pull Employees latest salary as well as previous salary. Does anybody have the logic or the sample report to achieve the …Sreeram V 1 view 1 comment 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service
-
How to remove link from two level report?Summary: Two reports with slightly different definition: the first is one level 'Report Definition One Level' and the second report has two levels 'Report Definition v3'…TinaB 1 view 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Multiple Duplicated for each column in report including Incidents and Threads tablesSummary: I build report with innerjoin b/w the tables incidents and threads. The report even with filters when pulled it shows multiple duplicates for each existing colu…
-
Customer Log in Stats on CP pagesSummary: My customer uses multiple CP launch points but one of which involves the customer to log in to access the functionality provided by the custom objects. We have …Colin Campbell-118909 31 views 2 comments 1 point Most recent by Colin Campbell-118909 Reporting & Analytics for B2C Service -
Can the service usage metrics reports be run via API and automated?Summary: Ive got anywhere from 20-30 active distinct instances and having to log into each and every one monthly to run the same report is a giant waste of time. Content…Justin_D 31 views 1 comment 1 point Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service -
Show incident and tasks in record viewSummary: I want to display a single incident in Record view and below it al its tasks. Content (required): I want to display an incident, say reference number, status, s… -
Report of incident after a ticket is closedSummary: To track the incidents post closure activity like reopening/ updated... Content (required): Suppose a ticket is been closed and later it got reopened. I have to…Boby B Jacob 31 views 2 comments 0 points Most recent by Boby B Jacob Reporting & Analytics for B2C Service -
what are tables in fusion to identify the Supplier B2B detailsSummary: what are tables in fusion to identify the Supplier B2B details Content (required): what are tables in fusion to identify the Supplier B2B details Version (inclu…Smandanak 51 views 2 comments 0 points Most recent by Smandanak Reporting & Analytics for B2C Service
-
How can I remove the text "Contains any" from the filter?Summary: I want to remove the "Contains any" text from the filter. as shown in the screenshot: thanks.Alfredo 51 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Distinct Records in Consolidated DashboardHi, I have 2 reports with same columns & filters from different tables. I want to combine into one report. I am using Consolidated Dashboard option with distinct values …Mohana Gopal S-Oracle 31 views 1 comment 0 points Most recent by Junie Rose Bodoso-Support-Oracle Reporting & Analytics for B2C Service
-
Turn Around Time calculation with 60/60/10.5 Extending Response TimeSummary: I'm trying to extend the response times to incidents. Not able to find anything in any forum that can assist. As example what I'm trying to accomplish here is w…
-
Get a list of documents information from report.Content (required): Hey Guys, I am in the process of cleaning up Oracle's document which lives in Document Explorer. And since we have a lot of document, I wonder if the…Vincent Lin 41 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service