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
-
Determine Last Row in $rowsContent Hi All, I have an issue with a report I'm constructing that I'm hoping you can advise me on. I need to construct a report that calculates the average message res… -
First response calculation per QueueContent Hi I need to know how to get the first response time of an incident for each queue it passes. Example: Incident created in queue A, the agent responds to the con…User_2025-02-03-17-19-40-969 38 views 4 comments 1 point Most recent by User_2025-02-03-17-19-40-969 -
'Agent Login' Report - Clarification on 'Login End Time'Content Hi, There is a delivered 'Agent Login Report' (Reports Explorer > Service> Agent Reports > Agent Login) that shows info on number of log ins, average time logged…User_2025-02-03-18-13-40-131 31 views 3 comments 0 points Most recent by User_2025-02-03-18-13-40-131
-
Create Workspace accessible outside of chatContent In Oracle Right Now. I am trying to create a workspace that contains realtime reports. So far I have only been able to have it accessible as a chat workspace whi…User_2025-02-03-17-52-47-539 18 views 0 comments 0 points Most recent by User_2025-02-03-17-52-47-539
-
calculate running balance?Content I'm trying to get a report to compile a running balance. I have custom fields to capture all the data, and I know I need a custom script for the calculation, but…User_2025-02-01-08-46-19-550 61 views 19 comments 2 points Most recent by User_2025-02-01-08-46-19-550
-
Please deleteContent Please delete
-
How to fetch the status history for an incident.Content Hello Everyone: I need to develop a ROQL query to retrieve the status history for each incident. Attached is the document containing the screenshot of the sample… -
Change Date Format in reportContent Hi, I was trying to change the date format as 01-May-2017.I tried changing configuration setting the date format was changed in workspace but it was not reflecti…
-
Save as default valuesContent Hello All - Could you please let me know where does (in which table) system store the 'Save As Default' settings of an individual user. Regards, Manpreet SinghUser_2025-01-29-18-11-35-209 31 views 0 comments 0 points Most recent by User_2025-01-29-18-11-35-209
-
How to report on Archived incidents sent with Attachments?Content Hi everyone, wishing you a nice weekend. I have a requirement to report on all Incidents sent from OSvC with an attachment in January 2017. I checked and the Arc…User_2025-02-03-16-51-39-328 52 views 4 comments 2 points Most recent by User_2025-02-03-16-51-39-328
-
Exclude results if all survey questions are not answeredContent Is there a way to exclude survey response that does not answer all questions? The report is showing multiple lines where a respondent has answered one question, …
-
Finding Contacts, not attached to any incidentsContent Over the time we have collected thousands of contacts through them contacting us and thus creating incidents. As part of the data protection we have been seperat…
-
Need help for calculating the days each status remain in for a given incident.Content Hello Gurus: While, I'm new to Oracle Service Cloud Reporting and Analytics, I've a specific requirement wherein we want to calculate the time (no. of days) for …
-
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
-
Maximum number of items in IN List filter?Content Is there a max number of items you can add in an In List filter? I can't seem to find this documented. Sometimes when I type in 1000 items it works (ie 'red,'blu…
-
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…
-
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…
-
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
-
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
-
Can I control the time element of a "Between" filterContent Hi All, New to custom reports, but I am starting simple. I am working on reports to simply show an incident count of tickets opened in our queue by month, and th…
-
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…
-
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 …
-
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…
-
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 …
-
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…
-
Incident Closures by Group - Analytics Cookbook RecipeContent Incident Closures by Group Total Closures versus Distinct Incident IDs Author: Colby Ross Difficulty rating: (Beginner) Target persona: Department Managers, Staf… -
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… -
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
-
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
-
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 …