To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
Report join should display info from Primary & Secondary tableSummary Report join should display info from Primary & Secondary tableContent I have contact table with primary employment detail and custom object secondary employment …User_2025-02-03-16-53-11-440 33 views 4 comments 0 points Most recent by User_2025-02-03-16-53-11-440 -
Changing date in report column from dd/mm/yyyy to dd/mm/yySummary Change from 4 digit year to 2 digit yearContent In Edit Definition I have tried date_format(fieldname,'DDMMYY') but it stopped showing the date and just repeated… -
How to show decimal places in 'average' column calculation?Summary Using the 'average' calculation is rounding, and I don't want it to.Content Hi everyone, I am trying to use "Edit Calculations" on a report column to get an aver… -
how to get the number of chats by siteContent We offer customers to start chat from customer Portal and brand website (by CCL link), i would like to identify how many chat coming from our custhelp pages and … -
Remove field in exported reportSummary Remove fields in exported reportContent I have 4 fields in my report. When I export the report, I want remove 1 fields and show 3 fields in the exported report.(…User_2025-02-03-16-53-11-440 17 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle -
Sort Incident Menu Custom FieldSummary Sort by Menu Order Option DisabledContent Hey all, I have a custom field in Incidents that is of the menu datatype and the menu items are being pulled from a men… -
Proactive Chat Offer Statistics #3033Content Is there a way to filter Proactive Chat Offer Statistics #3033 to show the originating webpage? I know how to distinguish the page using a custom field once an i… -
Removal of duplicate emails for a contactSummary Script to remove emails with .00XXContent Hi All, I've added the below script in one of my report to delete duplicate emails Scenario: email_alt1 is valid and em…User_2025-02-04-23-27-31-855 96 views 1 comment 0 points Most recent by User_2025-02-04-23-27-31-855 -
Report based on Virtual Table- Real time data update and Current Record ContextSummary Updates to External Data report based on Virtual TableContent Good Day, Can we fetch the current record context from a report based on virtual table (external da… -
Report Needs to Include Updated Messages, New Messages and %s and Real TimeSummary Updated Messages, New Messages and %s Percentages for queues - Real TimeContent I'm trying to develop a report that will give the 'Queues' current volume, volume…User_2025-02-01-07-43-22-355 32 views 0 comments 0 points Most recent by User_2025-02-01-07-43-22-355 -
Embedded URL ReportSummary How to show the file path of the attached file in an incidentContent Hi Everyone, I've working in my reports and i was able to show the attachments on each incid… -
Show corresponding filter valueSummary Show corresponding filter valueContent Hi, I have 2 filters ID & Name. User filter the report either by ID or Name. I show filter value in text item ((filter nam… -
Working from Home over VPN - Report could not be processedContent Reports that normally run fine in the office are constantly unable to process now and need to be queued....anyone else? Any tips? Thx! Version 19C -
Interval Type - Menu DescriptionsSummary Looking for full descriptions for menu itemsContent Hi. I'm looking for a published list with FULL descriptions/example for each of the Menu Items under Interval… -
COUNT on a COUNTSummary Counting how many responses were sent on an incident.Content I am calculating how many (transactions.trans_type='8') "Response Sent" transactions are taken on ti… -
How can we combine two RightNow reports into one?Content Active day for agent value for management purposes, we want to combine the information held in reports: * Public Reports > Service > Agent Reports > Agent Login … -
Contact Login ActivitySummary I am looking for a report that would detail the login activity for contacts that would be used in a number of different ways.Content For example: * A version of … -
Calculate percentage for responses received on the same day of incident creationSummary Calculate percentage for responses received on the same day of incident creationContent Hi, I have a requirement that I must calculate no of incidents that recei… -
Return a default record rather than "no records found"Content Hi, I have a Contact Quick Search report that if 0 rows are returned I would actually like it to default to a specific contact ID instead. I think that this coul… -
Filter on date format using a custom fieldSummary I need to filter a report on a date that is a custom fieldContent Hi all. We have a need to create a report that will filter on a custom field. The Field name is…User_2025-02-01-08-17-38-818 54 views 5 comments 0 points Most recent by Levi Dyckman-Support-Oracle -
HR Help Desk - Organizational hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t… -
Adding holiday to SLA after holiday has passed?Content Hello, We had an issue where Presidents day was added to our response requirements but NOT to our custom SLA. As a result, incidents from the weekend and Preside… -
Customize Date format in Service Cloud reports dynamicallySummary We have a requirement where users from world wide are expecting date formats to be displayed based on their location.Content Hi, Thanks for looking to help! Curr… -
Chat summary report - No value but serviced?Summary Chats have agent as 'No Value' but show as servicedContent We have copied the out the box report 'Chat Summary' (ID 3008). I've then added in a column for chats.… -
How to handle many-to-many relationships in reportingContent Hi Reporting Experts! I'm hoping you can help me with this one... I needed to set up a many-to-many relationship between Contacts and a CBO called Assisters. So,… -
How can I get a list of all Data tables available in Oracle Service Cloud ReportingContent Hello I'm presently picking up Oracle Service Cloud Reporting and I'm trying to get a list of all the data tables available along with a description of what they…User_2025-02-06-10-24-34-640 68 views 8 comments 0 points Most recent by User_2025-02-06-10-24-34-640 -
Help Adding % Totals to ReportSummary Help Adding % Totals to ReportContent Does anyone know to get the report roll up totals? see attachment. -
Adding Multiple Columns at Once to a ReportSummary Is there a way to add multiple columns at once to a report?Content Currently, we are wanting to export a sample of data from the incidents table using all of the…User_2025-02-03-17-53-10-691 54 views 2 comments 0 points Most recent by User_2025-02-03-17-53-10-691 -
Roll up data to be displayed in separate page on the PDF documentSummary Roll up data to be displayed in separate page on the PDF documentContent I have created 2 cross tab reports placed in the Dashboard. 2 reports are grouped(Roll u…User_2025-02-03-16-53-11-440 35 views 0 comments 0 points Most recent by User_2025-02-03-16-53-11-440 -
Closed and Created tickets in the same chartSummary Closed and Created tickets in the same chartContent Hello, Hope somebody has a clever idea on this. I have browsed through old posts but couldnt find my solution…