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
-
Last Agent LoginContent I would like to have a report to show the last time an Agent Logged in. I haven't been able to find anything in the tables to represent last login date. Does any… -
Chat TransfersContent I'm trying to figure out how many chats each agent transferred in a given timeframe. Any ideas where to start?
-
Report to show custom field usageContent I'm trying to put a report together that shows me how many times a custom field is used. The rationale being that I want to remove any unused fields! I fail to s…User_2025-02-03-17-03-04-780 61 views 9 comments 2 points Most recent by User_2025-02-03-22-07-33-802
-
can Organisation hierarchy changes be reported on?Summary I want to be able to report when a hierarchy level has changed for an OrganisationsContent Hi, This is my first time posting here - so hopefully there is a guru … -
Custom scripts to access controllers and modelsContent Hi, Can the scripts in reports access controllers/models from the custom portal? I'm trying via cUrl (and failing) so was wondering if there was a better solutio… -
Report to display Severity UpdatedSummary How many times severity updated for a incidentContent Hi, We have business requirement to get number of times severity got updated for one particular incident an… -
Ask A Question ReportSummary Report SummaryContent Hi, I would like to ask if there's a way to get all the data from Ask a question in customer portal? Basically, we set it up as a Pre-chat …
-
Passing Run-time selectable Date Range Filter to Custom Script of the ReportContent I have passed the run-time selectable date range filter to Custom Script of the Report. I have taken the FROM date and TO date in two variables convertiing epoch… -
Correct way to count incidents First Responded by a given Group?Summary Seeking best way to count incidents Initially responded to by an Agent GroupContent Hi all - we pay our frontline Call Centre based on # Incidents where they sen… -
answer feedback report with answer-ID, Question text, incident number and incident textContent Hi, I want to create a report showing all individual feedback per answer (preferably even a report that enables me to filter on either answer ID or product or bo…
-
Add Time Zone in Date Column in Report AnalyticsSummary How do I change the display of Date/Time in an output column?Content Hi, We have business requirement to change date/time in OSvC for each record. By default, th…
-
External Data Reports with Browser UI - Analytics Cookbook RecipeContent External Data Reports with Browser UI Expose External Data to OSvC Author: Scott Harwell, Principal Product Manager Difficulty rating: (Advanced) Target persona:… -
Search report results for contacts.any_phone_raw vs. any_phoneSummary Looking to understand why the rows analyzed are different for the two fieldsContent Why do the fields have a different number of analyzed rows if they're both se… -
Report description needed for end-user and kb answersSummary Report description needed for end-user and kb answersContent Where can I find a description of answer and end-user reports such as: Answer click through rate, an… -
Created and Closed/Resolved in the same reportSummary Creating a report (not a dashboard) with incidents created and closed/resolved in a period of timeContent Hello, I am trying to create a report that will include…
-
Aggregate functions last() is not working as expectedSummary last() should return last row of the data set, but it is fetching all the records.Content Objects : a) Incident b) CO.AuditLog (Custom Object). Joining Relations…
-
Report with link to attachments.Summary How do I get a report with a link to attachments for each incident?Content Hello, I have a report that shows the incident information and the attachments associa… -
Incident SizeSummary How to get size of incidents?Content Hi, Is there a way to return the total size of an incident with and without file attachments through reporting? A simple rep…User_2025-02-03-21-58-25-969 39 views 2 comments 0 points Most recent by User_2025-02-03-21-58-25-969
-
Passing filter value from one to anotherSummary Passing filter value from one to anotherContent There are 2 filters one for primary branch code and another for secondary branch code. Customer want to show sing…User_2025-02-03-16-53-11-440 32 views 2 comments 0 points Most recent by User_2025-02-03-16-53-11-440
-
Disposition of Incident when Survey went outSummary What was the disposition of the incident when the survey went out?Content I am trying to find the disposition of an incident at the moment the survey went out. I…User_2025-02-01-08-26-30-444 31 views 0 comments 0 points Most recent by User_2025-02-01-08-26-30-444
-
Contact custom records - display only record with latest date or just one if date blankSummary Return single latest customer record for a contactContent Our contacts have custom records in eg. myTable. They may have none, a single, or multiple linked recor… -
Time in statusContent For a given incident ID - what is the easiest way to show how long it has spent in each status Not status type - each status
-
Adding a Wildcard function to a Report Definition FormulaSummary I'm wanting to use an if statement in a report to search the subject title for a key word such as 'Accepted' and to return a custom value for this. Is it possibl…
-
Add the body of the ticket in a reportSummary I want to add the text-body of the ticket in a reportContent Hello All, I'm trying to create a report for all the tickets created in the last year that will have…
-
Phone search field with or without hyphensContent Many of our contact phone number have hyphens and more do not. I cannot find a solution for agent to search for a contact by phone number without them needing to…
-
Incidents report with Answers SummarySummary Creating a report joinning two tables with no common fieldsContent Hello! I can´t find a way to add the title of an answer (answers.summary) into the incident's …User_2025-02-06-21-26-19-557 33 views 6 comments 0 points Most recent by User_2025-02-06-21-26-19-557
-
Returning More than 10k Records on Scheduled ReportContent All, We have a report that runs every night that displays new records created in one of our custom objects in the past 24hrs. This report emails itself to a hand… -
Emails Received - Exclude Client Response to Auto Reply and Thank You ResponsesSummary Exclude Client Responses to Auto Replies and "thank you" responses to solved incidentsContent I am trying to update the Emails Received report to count the numbe…User_2025-02-07-10-02-12-918 37 views 0 comments 0 points Most recent by User_2025-02-07-10-02-12-918
-
Setting up multiple reporting schedules for different time periods within the same day.Summary Unable to change VRL_HARD limit, needing a workaround.Content Hi, I need to craft several reporting workarounds to report on previous days data via scheduled run…
-
Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?Content Hi, I've found when reporting on the chat_events table & sorting output by chat_events.created that two posts with the same second can be shown out of order. The…User_2025-02-03-20-01-45-901 19 views 2 comments 0 points Most recent by User_2025-02-03-20-01-45-901