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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Reporting & Analytics for B2C Service
Discussion List
-
How do I obtain an API tokenContent We're trying to use OSC to its fullest "Wow, great stuff, we'll stay with Oracle" potential and connect using a REST API connection to pull data into Alteryx -- …User_2025-02-03-20-43-46-497 58 views 3 comments 0 points Most recent by User_2025-02-03-20-43-46-497 -
Agent assigned incidents report displaying all agents (even with 0 assigned incidents)Content I'm attempting to create a report that displays a count of number of incidents that have been assigned to each agent over a specified amount of time. What I can'… -
Track how many questions are solved via Smart Assistant?Content Hi All, Could we able to track how many questions has been solved through smart assistant widget if the customer has clicked the button as "My question is answer…User_2025-01-25-05-06-24-395 18 views 4 comments 0 points Most recent by User_2025-02-03-18-50-34-224
-
Add field to search on 'Private Messages Per Channel Account' reportContent Hi Group, I'm trying to get help with a report (Private Messages Per Channel Account) that, when you right-click on a record, the option to create an incident ap…
-
Report: On average users are submitting how many tickets per month?Content Hello, I am wanting to reach out and see if there is any way to check on average how many incidents are users submitting via our Ask A Question page in a given m… -
ROQL: How to use CategoryHierarchyContent I have this: select Category.ID,Category.LookupName, COUNT(ID) as Total from Incident WHERE Source=1017 group by Category.LookupName order by Category.ID LIMIT 2…User_2025-02-03-19-49-57-702 42 views 0 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Count incidents when a date_group and count(*) is usedContent I have a report with 3 columns * DATE - date_group(incidents.created,'YYYY-MM-DD') * SOURCE - incidents.source_lvl2 * COUNT - count(*) So this shows how many inc…User_2025-02-03-19-49-57-702 57 views 5 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
String Replace Function in ReportContent Hi, I want to replace a character in a string in a report column. In the string function, I do not see string replace function? Since I have to access the report…
-
Hide row if a column contains a certain valueContent Is it possible to write a script to hide a row if a column contains a certain value? For example I have a report that displays all the cases for a queue but want…
-
Report - First response SLA from the first customer interaction (calcule)Content Hello, I have a use case that I import a CSV with the customers they bought from the store offering proactive help if they need it. These tickets are created wit…User_2025-02-03-17-19-40-969 14 views 6 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
PHP with Cross TabContent Hello All I am using Servicecloud to report on Grant information from a Grant Specific CRM. The Servicecloud reporting is considerably better than the Grant CRM.…User_2025-02-03-16-56-52-129 23 views 0 comments 0 points Most recent by User_2025-02-03-16-56-52-129
-
Including transactions disables report record commandsContent Hi Community! While working on improving the quality of data and reduce the amount of duplicate information in the system I have found that by joining the tasks …
-
How to replicate CASE statementsContent MY Query select Source.LookupName as Source, Incident.CustomFields.c.telephone_call as Telephone ,COUNT(*) from Incident WHERE Incident.StatusWithType.Status.ID …User_2025-02-03-19-49-57-702 24 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Separating chat agent intervals by hourContent Hello everyone, We are working on showing the number of minutes that certain agents were available during a specified time period, separated by hour. As of now, …User_2025-02-03-19-46-58-947 18 views 2 comments 0 points Most recent by User_2025-02-03-19-46-58-947
-
Viewing Popular Answers (Report ID 162) in ConsoleContent I'm trying to view the Popular Answers report but no Answers are displayed when I run it. Are CP reports only viewable on a CP Page?User_2025-02-03-18-13-34-376 36 views 3 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
Can you customize the list of items when you right click within a report?Content Is it possible to hide or add an option when your right click within a report that lists incidents? We need to be able to hide Forward from this list and am unab…
-
Displaying recent/last 5 records based on date/time information in a reportContent Hi, I have a set of reservation/booking data associated with contacts in RightNow. Now I am trying to take out a report where I can group the contacts and take o…User_2025-02-03-17-12-58-131 27 views 2 comments 0 points Most recent by User_2025-02-03-20-38-38-926
-
chat_launch page hit countContent Hello - We are trying to put together a report that will show us how many people land on our chat_launch page after hours. We have tried using the page summary r… -
Fetch last 5 modified recordsContent Hi Team, I have a report that fetches last created record using last(tasks.c$searchtime,tasks.created) formula. But now i want to have last 5 created records. so…User_2025-02-03-17-31-40-230 26 views 3 comments 0 points Most recent by User_2025-02-03-19-31-14-086
-
Validating Report Filter EntriesContent I've built a report that uses a formula to decide what fiscal period a record belongs to. Our fiscal months begin on the 22nd, probably in homage to my birthday …User_2025-02-03-20-43-46-497 12 views 1 comment 0 points Most recent by User_2025-01-29-22-08-41-708
-
Report View as a specific Account User when testing ReportsContent I'm an admin creating reports for my company's OSC implementation. I'm creating reports that I know will be used by users in a specific profile/nav set. As the a…User_2025-02-03-18-15-20-995 13 views 2 comments 0 points Most recent by User_2025-02-03-22-34-08-805
-
Filter in ExpressionContent How we can we use the filter on a report in an expression?User_2025-02-03-19-49-57-702 33 views 4 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
Help to Improve Efficiency of Transactions Query?Content Hi all, I recently rebuilt one of our oooooold reports that was originally created by my predecessor in the role. The original would break querying a days worth … -
Create custom report with Audit log of Account managementContent Hi all, I looking for generate a report where are centralice all staff account changes (Create, Update, Delete) with information field time created, user name, a…User_2025-02-03-17-57-33-602 60 views 4 comments 3 points Most recent by User_2025-02-03-17-57-33-602
-
Reporting of Operational metrics at the Email level, as opposed to the Incident levelContent Has anyone had any luck reporting on emails at the transactional level, rather than at the incident level? Would like to create a report that will shows metrics …User_2025-02-03-17-49-57-012 36 views 4 comments 0 points Most recent by User_2025-02-03-17-57-37-588
-
Scheduled Reports - Record Limit - VRL_HARD - configuration settingContent We have some scheduled reports that are being cut off at the 15000 record limit. Just want to confirm if increasing the VRL_HARD - configuration setting will car… -
Report showing Agent who add Incident CommentsContent I am looking to create a report that will show the name of the agent that added comments to an incident. We use a Custom Object to hold the comments that an agen…
-
Popup message box upon running a report?Content Could someone please tell me whether it is possible (perhaps using custom scripts?) to present a dialog box when a user runs a report? I'd want the message box t…
-
Chat Total DiscrepancyContent I have 2 columns, each returning different chat totals and I'm not sure why. My columns are: * COUNT(chat_agent_sessions.chats_completed) * SUM(IF(date_diff(chat…User_2025-02-03-16-48-16-590 14 views 3 comments 0 points Most recent by User_2025-02-03-16-48-16-590
-
Actual Response TimeContent Hi, Need help to design a report which will give the actual response time of incidents. I checked couple of standard reports but all of them either give the Crea…