Reporting and Analytics
Discussion List
-
How to get the time of incident reach to a particular queueHi, I need to Show date request was moved to a particular queue. How to find that? Also I need to show the initial severity of the case. Regards, MeeraMeera Saseendran T 22 views 3 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service -
Add a link report to a report total calculationSummary: Add drilldown on a total count column. Content (required): I have a report that has a column count. I add a total count for the column I select from the Design …
-
How to add profile creation and queue creation date in reportSummary: Hi community, How we can add profile creation date and queue creation date on reports in Oracle service cloud reports As a first step i have verified that we do…Santosh kumar purusottam 12 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L…Praveen Gopalakrishnan 21 views 2 comments 1 point Most recent by Praveen Gopalakrishnan Reporting and Analytics for ERP -
What is this report symbol meaning?Please help me to understand what is this symbol on left of a report name. Regards, MeeraMeera Saseendran T 13 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Change "from" address and seeing recipents on scheduled reportsContent Hi Gurus, I have two questions in schedule report Can we change the from address for the schedule report? Can we see the list of recipient email address in the t…Mohana Gopal S-Oracle 52 views 7 comments 0 points Most recent by Santosh kumar purusottam Reporting & Analytics for B2C Service -
How to extract holiday list ?Hi, Is there any way, we can export holiday list of each SLA? Regards, MeeraMeera Saseendran T 41 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service
-
how to add a column for who closed incident in a reportHi, I need to add a column in a report. How to get incident closed by details in a report? Regards, MeeraMeera Saseendran T 31 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
How to add drill down to total in reportsI need to add drilldown report to total of cases: How to do that? Thanks, MeeraMeera Saseendran T 21 views 4 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
How to get total email count and AHT in a reportI am looking for a way to get a count of all emails sent by the customer, and average handle time for the agents (AHT) in a particular queue. So if a customer sends 3 em… -
Finish tab in custom script reportSummary: Can any one help us how we can use custom script in service cloud report Content (please ensure you mask any confidential information): We have successfully abl…Santosh kumar purusottam 22 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
How to add total in custom reportHi, Like above report, I need to show total in a report. How to do that? Regards, MeeraMeera Saseendran T 21 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Hi is there any report for ODA in Oracle Service cloud(.Net Console)Summary: Is there any report I can download or use in the Oracle Service cloud to report on ODA? Content (required): Hi All, We recently launched ODA for Chat in the Ora…Vincent Lin 21 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting & Analytics for B2C Service -
Report to get the contact details from the system using mail domain as filterSummary: Hi , I have a report requirement in the Oracle B2C console where I will be feeding the customer email domains. It may be 1 or many, depending on the requirement…Boby B Jacob 11 views 2 comments 0 points Most recent by Boby B Jacob Reporting & Analytics for B2C Service -
SQL query for Time Entries with Payroll result for the selected periodHi All, I have a requirement to fetch the columns as attached in the excel screenshot. The challenge i'm facing is i'm not aware how to join the Time Entries with Payrol…Dilip.Murugan-Oracle 31 views 0 comments 0 points Started by Dilip.Murugan-Oracle Reporting and Analytics for HCM
-
Is there an automated way we can view the updated date of standard texts?Summary: I am trying to get a list of all of our Standard Texts along with the date each was last updated. If I go into the Standard Text editor in the .NET console, I c…Andrew! 11 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
Error on workpsace after adding a reportHi, Iam getting this error after adding report in workspace tab The report contains the following errors: -found flat branch for grouped parent You will need to edit the…Meera Saseendran T 11 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
how to add actions in reportHi, How we can add actions like open and delete ina report ? like below: Regards, MeeraMeera Saseendran T 35 views 2 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Capacity chartHi, I need to create a capacity chart. •For incidents without a task, use the Due date to allocate the effort into the weekly intervalFor incidents with tasks, use the t…Meera Saseendran T 11 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Some of the fields in the OTBI subject area are not populating valuesWe are trying to select "check number" from the OTBI subject area "Payables Payments - Disbursements Real Time" but the field results no values in it due to which the da…
-
How to pass Incident field as run-time filter to standard Search knowledge base reportSummary: I have an incident field, based on which the Search Knowledge base report in the Rich Text editor should be filtered. I want to filter answers.nl, based on the …Yashwanth Siddaraju 21 views 1 comment 0 points Most recent by James Branston Reporting & Analytics for B2C Service
-
how to fetch 3rd level of categoryHi, I need to add 3rd level category to a script for showing it in incident workspace. WHich field to choose for this? Regards, MeeraMeera Saseendran T 2 views 1 comment 0 points Most recent by James Branston Reporting & Analytics for B2C Service
-
Incident Transaction Counts (Multiple Transaction Types) - Analytics Cookbook RecipeContent Incident Transactions Counts Vanilla Report Counting Multiple Transactions Types Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Diffi…User_2025-02-03-19-30-01-975 223 views 10 comments 7 points Most recent by User_CTDKD Reporting & Analytics for B2C Service -
Hi all, in bursting can I put the dynamic file name? example concatenate it to today's launch date!Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for B2C Service
-
Time in Status (Transactions Calculation w/ Custom Script) - Analytics Cookbook RecipeContent Time in Status Calculates time using custom script Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Targe…User_2025-02-03-19-30-01-975 333 views 9 comments 15 points Most recent by Archana Rajendran Reporting & Analytics for B2C Service
-
Join chat_queue_stats with Incidents TableSummary: When I join Join chat_queue_stats with incidents table, it removes data and shows blank I need to join the tables, becuase I need to know what agency the client…Marissa Gonzales 51 views 7 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
Analytics CookbookContent Welcome to the Analytics Cookbook! This is an exciting resource intended to help with your Oracle Service Cloud Analytics. How do you measure the value your orga…Kenny Tietz-23935 6.6K views 3 comments 64 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
how to calculate incident edit time for each transactionsSummary: Hi, I need to create a report for getting incident edit time of an incident. edit time for each agent in same incident is needed. Regards, Meera Content (please…Meera Saseendran T 11 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Ask a Question FormSummary: Does anyone know the maximum number of characters that can be in the Summary and Question fields on the Ask a Question form? Content (please ensure you mask any…Dorothy Norman 91 views 3 comments 0 points Most recent by Dorothy Norman Reporting & Analytics for B2C Service -
how to enable add existing option in contact tabHi, How to enable the option for add existing contact in a workspace.? Regards, MeeraMeera Saseendran T 51 views 2 comments 0 points Most recent by Jess Campbell Reporting & Analytics for B2C Service