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
-
How to check against previous cell/row and highlight rowContent Hi, I am using custom scripts in my report. One column I have values as below: * A * B * B * C * C * C * D * D * D * D I would like the row to be a certain colou… -
'Expanded Report Audit Log'Content We have upgraded our instance to 18D. I was looking forward to this report 'Expanded Report Audit Log', but currently I am seeing any data in it even though ther… -
Aggregate functions first() or last() do not work as expectedSummary first() should return first value of the aggregated column, but if the value is No Value, it actually returns the next value that isn't No ValueContent Here is h…
-
Chats Report not functioning before February 2019Summary Chats Report not functioning before February 2019Content Hello, I created a report for Chats and it's not functioning on any period before February 2019. I added… -
Report Date in Scheduled Report Subject or AttachmentContent Hello, Is there a way to have the date of the report included in the Subject of a scheduled report? Also, is it possible for the name of the attached report (in … -
How to replace the report data with custom array using Custom script in Reports.Summary How to replace the report data with custom array using Custom script in Reports.Content Hi , I have a report which uses Custom Script to calculate time differenc… -
rel_date_diff as a report filterSummary I have a report that requires rel_date_diff as a filterContent HI, I have designed an SLA report on Oracle Service Cloud, with the requirement to filter and show…
-
Joining Custom Object table with incidet TableSummary I want to join my cusotm object table with the incident table using the ref_no fieldContent I have a custom object that contains the ref_no field that I have imp…
-
Hiding duplicate incident counts for reportingSummary Incidents are currently pulling in multiple times due to multiple thread comments per incidentContent I am trying to create a report that shows a count of incide…
-
Password protected reportsContent Hi, This is similar requirement like another post. Just created new post for better visibility. https://cloudcustomerconnect.oracle.com/posts/c3d13d17f2 Has anyo…
-
Report linking not workingSummary I tried to link to reports but for some reason, the linked report is not showing any dataContent Hello, I have been trying to link two reports in vain. I have de…
-
Notify admin when a report has been set to deferred executionSummary Test site gives me desktop alerts whenever a report is set to deferred execution, how can I configure this in production?Content In my test site, whenever a repo…
-
How to query average file attachment sizeSummary Report or ROQL to get average file attachment size.Content Hi does anyone know if there is a method for reporting the average file attachment size for all files …
-
Calculated Column to Show Time Until Aged Database Utility sets an Incident to Solved?Summary I am trying to find a way to display a calculated column that will show the amount of time remaining before the Aged Database Utility changes an SR from Waiting … -
How to set Category filter in analyticsReportResults using Connect REST API ?Summary How to set Category filter in analyticsReportResults using Connect REST API in POSTMANContent Hi all, I am trying to run a report with these columns: "columnName… -
Getting Standard Deviation of task completionSummary Getting Standard Deviation of task completionContent Hi all, I am getting Standard Deviation of task completion in TASKS table. I was intending to use STDDEV fun…
-
List of all Oracle Scheduled ReportsSummary Is there an area and/or document in Oracle Fusion to list all available canned Scheduled Process Reports?Content We are only as good to what we know and have bee… -
Using rel_date_diff() as an expression or in any of the calculationsContent Hi All, We are trying to write a if condition which has rel_date_diff() function. But, getting the error that, this function cannot be used as an expression. Bel…
-
Add Report Generation Date, Time and Generated by information in header or FooterSummary Add Report Generation Date, Time and Generated by information in header or FooterContent Kindly advise how to add report generation Date, time and generated by i… -
Value of variable set by custom script not available to other columns?Content I've searched around a bit, but I haven't seen an answer to this one... I have a custom script that is setting a variable in the process tab. I have a column tha…
-
Steps to do RFM Analysis for Transactions data in CO within Oracle Service CloudSummary RFM Analysis for Transactions in Oracle Service Cloud [RightNow]Content RFM Analysis RFM [Recency, Frequency, and Monetary] analysis is an effective measurement …
-
Custom Audit Log for Custom FieldsSummary Create a report to display an audit trail of changes to a custom fieldContent Is it possible to create a report to display an audit trail of changes to a custom …
-
Surveys MetricsSummary We need details aboaut our sent surveysContent Hello! We send several surveys every day , and we need to know by month the metrics of performance: how many surve…
-
Incident Report for Users who reassigned IncidentsSummary Are there reports to show users who reassigned incidentsContent Hi Guys, We have users/staff who don't respond to customers. The customer facing users receive in…
-
There was an error getting SRM rows. see logs for detailsSummary Error in SRM acceleratorContent Hi Guys, Has anyone encountered this error when trying to open an incident workspace of an incident that sent to Service Cloud ut…
-
Indexing a custom fieldSummary Index option is disabled for Custom FieldsContent Hi, We are having set of fields configured under Custom Fields option under Database. But the "Indexed" checkbo…
-
Report in chat workspace filtered by incident custom fieldContent Hi, I have created a report (filter based on incicent custom field) and added it to the chat workspace (in a tab) so that agents can see previously created incid… -
Report for when another agent enters a noteSummary We are trying to flag/highlight a row on a report that indicates when another agent has logged a noteContent We are trying add an exception to a report that indi…
-
Screen pop a report that uses "in list" filter?Content (Sorry for cross-posting with Service Console - not sure if people read both.) I've created a report that searches for contacts using the "in list" filter. (cont…
-
Trigger event, code etc when a row has been editedContent Hi, I have inline editing enabled on my reports and I'd like for some code, PHP to be ran when a value changes from one to another Is this possible? Thanks, JJ