Reporting and Analytics
Discussion List
-
Is There a More Detailed Database Dictionary?Summary: Is there a more detailed database dictionary for Oracle Service Cloud? Content (required): For example, I am finding that some of the information in the Databas…NDKoze 1 view 1 comment 1 point Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Find e-mail address in incident threadSummary: How can I make a report with an e-mail address in one column that is used to search in the initial customer thread in another column. With a third column showin… -
Organization Hierarchy ReportingSummary How to Correctly Report the Levels of an Organization's Hiearchy?Content I am trying to create an Organizational Hierarchy report that shows the number of Contac…
-
Can we trace categories changes in Audit LogSummary: Tracing categories changes in the Audit Log Content (required): As we all know, we can trace the incident transactions through the Audit log. But one of my clie…Vikash Patel 11 views 2 comments 0 points Most recent by Sasi Gudimetta-281012 Reporting & Analytics for B2C Service -
Help reporting on a button clickSummary: Need help reporting on a button click Content (required): I'm attaching my simple report definition (zipped xml) for when an agent clicks a button in their work…kerry walker 11 views 6 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Schedule a Dashboard to be emailedContent Hi All, It doesn't seem that we have the ability to schedule a dashboard to be sent to a group of email recipients, so I'm wondering what solutions you all use t…
-
Which table should I use to calculate agent login time?Summary: Do I need to develop a report that calculates the login / logout time and which table is the most correct to use? accountsessionhistory or user_trans.type = 1? …Leonardo Santos 1 view 5 comments 0 points Most recent by Sristy A Reporting & Analytics for B2C Service -
Is it possible to find all the reports with their filter details ?Summary: We need to fetch all the reports in the system that do not have a Date filter in them as we need to then edit those reports . Content (required): Version (inclu… -
contacts.any_phone_raw is not returning data when searching for Contact Phone Alt 3Content We have a search report set up that utilizes contacts.any_phone_raw which based on the Data Dictionary should search within any phone number field on the contact…Famirka Then 5 views 2 comments 1 point Most recent by Lakshay Bhalla Reporting & Analytics for B2C Service
-
Why my Logon Reports show duplicate rows?I did a new Logon Report to show start/end by day. But it is running with duplicate rows for each Agent, I would like show one row only. I'm using account_session_histor…Leonardo Santos 11 views 5 comments 0 points Most recent by Kurt Helfrich Reporting & Analytics for B2C Service
-
"Records" is greyed out on the report, cannot edit even if I have permissionSummary: "Records" option on report design Content (required): Hi friends, I have an old report that I need to edit. I want to edit the records that can be opened from t… -
Duplicate contact email addressesSummary: Looking for downsides to allowing duplicate email addresses Content (required): We've recently come across a few reasons to allow duplicate email addresses for …kerry walker 1 view 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Search in Answer Source (Using Custom Script) - Analytics Cookbook RecipeContent Search in Answer Source Using a custom script Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Target per…Bastiaan van der Kooij 96 views 7 comments 10 points Most recent by Ssimpson-Oracle Reporting & Analytics for B2C Service -
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting & Analytics for B2C Service -
How much data is too much dataSummary: We struggle with reports not running due to too much data. We average about 45,000 open incidents a day. Our oldest ticket is year and a half old. We are lookin…Jeff Scrobel 11 views 0 comments 0 points Started by Jeff Scrobel Reporting & Analytics for B2C Service -
We need a report on Anchors.Summary: Anchors arent represented well in answers and their solutions. How can we search for them? Content (required): I made a report to search an answer solution for …
-
What is the Proper Syntax for an Exception Report Using the IF ArgumentSummary: Looking to change the color of the text when a result is outside of a SLA Using an Exception Report With a Logical Test Content (required): The report I've writ…Chuck Udzinski 1 view 2 comments 0 points Most recent by Chuck Udzinski Reporting & Analytics for B2C Service -
Enhanced Business Rule 2.0 LogSummary How to access EBR logContent Hi Can we access Enhanced Business Rule 2.0 log in BUI or in Agent Console. I know we can access legacy business rule from left navi…Baljeet Singh-231094 5 views 2 comments 0 points Most recent by Baljeet Singh-231094 Reporting & Analytics for B2C Service -
List of answers sent by agents on chat interactionsSummary It is possible to access chat_events.data_str in reports?Content Customer requested a report to list answers sent by agents over chat interactions. Reviewing cha…Agustin Pinto 11 views 3 comments 0 points Most recent by Agustin Pinto Reporting & Analytics for B2C Service -
Option to reset search filters in contact search reportSummary How can we enable agents to reset the search fields to serve the next customer?Content Hi there, We have an issue with search reports when agents use them; when …
-
How to relate contacts and campaigns through reportsContent Hi All, Do we have an option for relating the contacts and campaigns through reports ? I want to create a report that shows the campaigns associated to a particu…Nishi 6 views 1 comment 0 points Most recent by Robert Conrad-148226 Reporting & Analytics for B2C Service -
Need to add exceptions to dashboard reportsContent Need to add exceptions to dashboard reports to give a visual indication as to where a request is in relation to its estimated resolution time (SLA) The requireme…Ramesh Kandula-122118 13 views 3 comments 1 point Most recent by Pavol Procka Reporting & Analytics for B2C Service
-
First Time Chatter ReportSummary We are needing to keep track of "new" chattersContent I am trying to count the amount of new people chatting into the call center. We are trying to account per o…
-
Report to show who has assigned an incident on to another person or groupSummary Report to show who has assigned an incident on to another person or groupContent Hi i currently have a report which counts the number of incidents solved and uns…Jonathan Smith-120851 21 views 5 comments 0 points Most recent by Sristy A Reporting & Analytics for B2C Service
-
Incident Closedby ReportContent Hi Gurus, How to capture the closed by account in reports? I tried to get it from transaction table using Description equals 'Closed' filter. But no luck. Thanks…Mohana Gopal Selvam-Oracle 14 views 3 comments 0 points Most recent by Sristy A Reporting & Analytics for B2C Service -
Report using Custom ScriptsContent Hi everyone, I have a requirement to create a report where we can display the number of incidents that has been routed to a different queue but only when the inc…Vaishali Rajput 30 views 2 comments 1 point Most recent by Rakesh Das-Oracle Reporting & Analytics for B2C Service -
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to get started with your Oracle Cloud Applicat…This discussion has been merged.Bethany Hubbell 5 views 0 comments 1 point Started by Bethany Hubbell Reporting & Analytics for B2C Service
-
Display X number of recordsSummary Display X number of recordsContent We want to create a top 10 report and only display the top 10 in the report results. I thought I had a example script I used f…JLFolkman 12 views 7 comments 0 points Most recent by PavanSatishKumar Annavarapu-Oracle Reporting & Analytics for B2C Service
-
Round date value to the last day of a monthSummary How to convert a given day to the last day of that month?Content Dear reader, Have looked in the report functions (Functions (custhelp.com)) and actually I'm loo…
-
Agent login count is coming 0Content I'm creating a report that counts agent logins in RN, but in the column where it should count the number of logins, 0 is coming. What could be happening? Version…Leonardo Santos 9 views 1 comment 1 point Most recent by Sristy A Reporting & Analytics for B2C Service