Reporting and Analytics
Discussion List
-
Chat Origins - using custom object fields?Content re: https://cloudcustomerconnect.oracle.com/posts/1da47425c4 I'm planning to implement something almost identical to this, though we don't use Engagement Engine.…User_2025-02-03-17-31-49-785 18 views 1 comment 0 points Most recent by User_2025-01-29-22-08-41-708 Reporting & Analytics for B2C Service -
Chat Origins with Engagement Engine - Analytics Cookbook RecipeContent Chat Origins with Engagement Engine Report on detailed sources of syndicated chats Author: Simon Kilgarriff Difficulty rating: (Beginner) Target persona: Anyone …Simon Kilgarriff-118560 41 views 2 comments 7 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service -
Displaying all rows in aggregate report, even those where count = 0Content Hi there, I have a report that shows me how many incidents of type A are assigned to each account with profile ID of X, filtered by the date range during which t…User_2025-02-03-18-15-18-780 30 views 3 comments 0 points Most recent by User_2025-02-03-18-15-18-780 Reporting & Analytics for B2C Service -
Filtering out from a report any incidents which are not the last (or most recent) incident assigned.Content Thanks in advance for any help - really appreciate it! I have a report that shows me several fields of the last incident related to all of my organisations. To a…User_2025-02-03-18-15-18-780 41 views 4 comments 0 points Most recent by User_2025-02-03-18-15-18-780 Reporting & Analytics for B2C Service -
Outer join not pulling through all incidents - just where they have a relationship to an incidentContent Hi, So: * Added a incident reference * Added transaction type * Added transaction id3 * Did outer join * Filtered transactions on type =**** and id3 in A,B,C The…User_2025-02-03-19-49-57-702 19 views 3 comments 1 point Most recent by Danette Beal Reporting & Analytics for B2C Service -
Chat Total for Chats Received by QueueContent What expression will show me an accurate total of chats received (not necessarily completed) by queue? 95% of our chats filter through our contact center, but ma…User_2025-02-03-16-48-16-590 21 views 8 comments 0 points Most recent by User_2025-02-03-16-48-16-590 Reporting & Analytics for B2C Service -
Disabled Report Link Error when saving a report.Content I was looking at the following recipe: https://cloudcustomerconnect.oracle.com/posts/e767416f65 This looks like something I could really use. Not sure what I am …User_2025-02-03-16-51-39-328 46 views 1 comment 0 points Most recent by Colby Ross Reporting & Analytics for B2C Service -
Bring back earliest dates in seperate columns then combine to single rowContent I have this data. #s0 {font-family:Segoe UI ;font-size: 9pt; font-weight: bold; color:rgb(68,68,68);text-align: left; vertical-align: bottom}#s1 {font-family:Seg…User_2025-02-03-19-49-57-702 23 views 1 comment 1 point Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
How to select all when using IN LIST?Content * So I have a column I want to filter on. * Because it's free text, when I select "IN LIST", nothing is selected and I have to type stuff in. * I could either pa…User_2025-02-03-19-49-57-702 21 views 7 comments 1 point Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service -
Total Incidents in Unresolved Status at a Given TimeContent I am editing this, because I realized I didn't even realize what it was I needed when I asked (head: meet desk) Essentially what I need is the ability to get a c…User_2025-02-03-22-22-34-586 29 views 18 comments 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
How to pass one output column as a filter in another report using custom scriptContent HI All, I am very new to custom scripts and can we able to do the below requirement using the custom script. For example : In contacts level, we have a bank id a…User_2025-02-03-18-29-17-316 42 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Customer Response Show in HTML FormatContent Hi All, I am facing issue while calling a report in the Customer Portal template. In that the customer response column shows as HTML content but actually in the …User_2025-02-03-17-20-54-699 23 views 1 comment 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Filter Text field as DropdownContent Hi Gurus, We have one text field in the custom object. While exposing a the text field in the report for the custom object, we need to choose the values similar …Mohana Gopal S-Oracle 28 views 13 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service -
Getting Clickstream data from our message baseContent Hello - We have a message base/banner on our home page of our knowledgebase site. At this time, the message that is on there has two links that we would like to …Hanna Page 16 views 3 comments 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
Want to display date format as FY16/FY17 so on, in a Report columnContent Hi All, In a report column I want to display as FY16 if Incident start date is between 01/Oct/2015 to 30/Sep/2016 and FY17 if incident start date is between 01/O…Ashwitha S-119365 12 views 4 comments 1 point Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
NetPromoter Score (NPS) - Analytics Cookbook RecipeContent NetPromoter Score (NPS) Calculating Your NPS for the Last 7 Days Author: Simon Kilgarriff Difficulty rating: (Intermediate) Target persona: Marketing/Survey Anal…Simon Kilgarriff-118560 54 views 5 comments 6 points Most recent by Simon Kilgarriff-118560 Reporting & Analytics for B2C Service -
Based on date, value should display in a Report columnContent Hi All, There are two columns in a Report. One is Date column which display date in DD-MM-YYY HH:MM AM/PM format and one is Items column (will display item names…Ashwitha S-119365 30 views 2 comments 0 points Most recent by Simon Kilgarriff-118560 Reporting & Analytics for B2C Service -
lost inbound emailContent Hi friends ! We have an issue : * A client called us trhought the phone * we created an incident on Agent Desktop * The agent sent a reponse by mail to the custo…User_2025-02-03-17-27-29-599 12 views 2 comments 0 points Most recent by User_2025-02-03-17-27-29-599 Reporting & Analytics for B2C Service -
Advanced Analytics w/ BI/Data Visualization for OSvC - Analytics Cookbook RecipeContent Advanced Analytics for Oracle Service Cloud via BI/DV Accelerators The adoption of business analytics across enterprises has seen a paradigm change over the past…Kenny Tietz-23935 110 views 4 comments 4 points Most recent by Mehrzad Kootar Reporting & Analytics for B2C Service -
Live Chat Stats for a TV DashboardContent Does anyone or has anyone built a live or within XX amount of mins dashboard that gives 1 line showing the total of all chat groups. I have totals by queue but c…User_2025-02-03-18-52-34-989 14 views 3 comments 0 points Most recent by User_2025-02-01-08-38-15-811 Reporting & Analytics for B2C Service -
Filtering Based on Logged In Account GroupContent Is it possible to filter rows in a report based on the signed in accounts assigned group? My first thought was to use a custom script to get the logged in user i… -
Exception Alerts to Assigned AccountContent I have 2 exceptions on an Incident report that fire when an Incident hasn't been updated in either 3+ days or 7+ days. Is there a way to send an alert to the age…User_2025-02-03-16-48-16-590 15 views 2 comments 0 points Most recent by User_2025-02-03-16-48-16-590 Reporting & Analytics for B2C Service -
Applying a Grouping to a calculated columnContent Hi All, I have created a computed column called 'Outcome' based on the values in a text field. I want to now group and count based on the computed field 'Outcome…User_2025-02-03-16-59-32-682 23 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
Showing all related incidents in a reportContent Hi All We have added a incident system attribute so we can relate incidents. As its only a Parent/Child relationship and service cloud doesn't support automatic …User_2025-02-03-19-35-06-088 22 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
How to handle Custom reports in CPM?Content Hi All, Is there any way to handle custom reports in CPM? When I query with the report ID am getting only the ID, Name, Created and Updated time. How to get the …User_2025-02-03-19-33-02-045 16 views 2 comments 0 points Most recent by Scott Harwell Reporting & Analytics for B2C Service -
Pie Chart based on Incident SeverityContent Hi All, I have a requirement to create a report with pie chart which should be grouped based on incident Severity. i.e. if there 4 severity values 1 to 4, there …User_2025-02-03-19-24-48-785 35 views 5 comments 0 points Most recent by Hanna Abi Akl Reporting & Analytics for B2C Service -
Report on Incident where secondary contact is XContent We have a Sales Engineer who is attached to several incidents as the secondary contact and he wanting a report view of all incidents where this exists. Is this p…User_2025-02-03-17-55-26-866 18 views 7 comments 0 points Most recent by Srinath Srinivasan-Oracle Reporting & Analytics for B2C Service -
How to increase character limit from 200 for text columns in reportsContent I'm trying to run custom reports on Survey text responses and I see that the responses are truncated after 200 characters. It seems that only the displayed value…User_2025-02-03-16-37-41-587 35 views 1 comment 1 point Most recent by Justin_D Reporting & Analytics for B2C Service -
Filtering out IPs (Updated June 2017)Summary List of IPs to exclude from web analytics (as of June 2017)Content List of IPs to exclude from web analytics (as of June 2017)We currently use performance monito… -
Autopopulate report filtersContent Hi , Can we auto populate the report filters with workspace field values ? Attached the screenshot, where we want to have the value of filter auto populated with…User_2025-01-29-00-47-12-825 46 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service