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 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 -
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… -
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…
-
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
-
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… -
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
-
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
-
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
-
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
-
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
-
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 … -
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… -
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
-
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
-
ROQL Multiple FiltersContent Currently have the below but looks like just the second one is listened to and not the first, please advise how I'd pass multiple filters using ROQL to an analyt…
-
Custom Report to Save CC from Mail HeadersContent Hi, We would like to start storing the email addresses in the CC field (if any) when incidents are created via email. I was able to determine that this informati… -
Logged In Id in CustomScripts ofreportsContent Can we get Logged in Staff Account Id in Custom Scripts of Reports: It seems the below code is not working. Can someone help how to get Logged in Account's Id in…
-
Cross Tab rollup totalsContent Is there a way to move the rollup total in a cross tab report to the row with the Rollup Column Name, so it looks more like an Excel Pivot table? Then when the R…
-
Advanced Analytics w/ BI/Data Visualization for OSvC - Analytics Cookbook RecipeContent Advanced Analytics for Oracle Service Cloud via BI/DV Accelerators The adoption of business analytics across enterprises has seen a paradigm change over the past… -
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…
-
Obtain URL address of OSC variablesContent Hi all, I have to build a report using an analytical tool and I need to extract the data from Oracle Service Cloud. So far, I was able to identify the source of …User_2025-01-28-18-24-20-836 16 views 1 comment 0 points Most recent by User_2025-02-01-08-58-47-501
-
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…
-
Report exception if staff account is not logged inContent Hi all, I am looking for a little help with an existing report. So I have a basic report which shows the following: Staff Member (incidents.assgn_acct_id) Overdu…User_2025-02-01-08-29-25-648 50 views 3 comments 0 points Most recent by User_2025-02-03-18-10-34-197
-
Exception email trigger when incident enters queueContent Hi everyone, happy Friday I am looking for a solution where an email notification is triggered in real-time whenever an incident enters a queue. e.g. incident 17…User_2025-02-01-08-29-25-648 25 views 3 comments 0 points Most recent by User_2025-01-30-19-06-33-073
-
Report of Incidents by Hour / Queue / StatusContent Hi - I wonder if anyone can point me in the right direction for solving this report request that I have been given: "A report by hour of how many incidents are i…
-
Live Chat Stats for a TV DashboardContent Does anyone or has anyone built a live or within XX amount of mins dashboard that gives 1 line showing the total of all chat groups. I have totals by queue but c…User_2025-02-03-18-52-34-989 14 views 3 comments 0 points Most recent by User_2025-02-01-08-38-15-811
-
Total Incidents in Unresolved Status at a Given TimeContent I am editing this, because I realized I didn't even realize what it was I needed when I asked (head: meet desk) Essentially what I need is the ability to get a c…User_2025-02-03-22-22-34-586 29 views 18 comments 0 points Most recent by User_2025-02-03-19-30-01-975
-
IP Address of chat customer in real time reportContent For the Chat tables in Oracle, there are several real time and several historical tables. The IP address of the person chatting with our agent is available to th…
-
Automatically print or forward incidents from a reportContent I have a simple report that returns incidents assigned to a specific exit category. Is it possible for Oracle Service Cloud to: 1) run this report at 5pm ET on w…