Reporting and Analytics
Discussion List
-
Expired vs. Cancelled ChatsSummary Which is the calculated abandoned rate?Content Can anyone advise on What is the industry standard to calculate the abandoned chat rate? Do we include the expired…Dorothy Norman 20 views 1 comment 1 point Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
A 'How to' on using regular expressions in custom scripts for GDPRContent GDPR, how to find sensitive data in a report using regular expressions in custom scripts. This is a how to for those new to reporting and custom scripts :-) Cust…Sebastiaan Draaisma-122509 214 views 9 comments 22 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Total of Incidents last updated by customerSummary Total of Incidents last updated by customerContent Hello, I'm using this formula to indicate whether a customer last updated an incident: substr(max(concat(date_…User_2025-02-03-21-48-33-357 46 views 2 comments 0 points Most recent by User_2025-02-03-21-48-33-357 Reporting & Analytics for B2C Service -
Logged In/ Logged outContent Hi, I have a report that I am trying to add to it an exception that if the assigned account is logged out then highlight in red. I have found many posts here tha…User_2025-02-03-18-10-34-197 59 views 11 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
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 Reporting & Analytics for B2C Service -
Can't get LIKE operator to work if there's a spaceContent Hi I'm trying to set up an alert on a custom report to fire if the incident thread contains "customer data". I'm using the filter incidents.search_thread like %c…User_2025-02-03-20-01-45-901 47 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
ADF Contextual Event with prompted reportSummary My ADF Contextual Event takes me back to main screen instead of back to Details reportContent Hello, Does anybody have experience using the ADF Contextual Event …User_2025-01-22-20-09-02-352 61 views 3 comments 2 points Most recent by User_2025-02-04-10-48-17-393 Reporting & Analytics for Sales -
Reports: The number of incident closed at first contactContent Hi All, I have an requirement to show The number of incident closed at first contact. can any one help me to do this how?Sathya Rajendran 29 views 8 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Aggregate responses per incidentSummary Creating a report to show the aggregate responses per incident (RPI), but getting duplicate values and unable to group results.Content Hi all I'm attempting to c…User_2025-07-18-00-44-03-945 48 views 1 comment 2 points Most recent by D.J.C. Reporting & Analytics for B2C Service -
How to track video views within an AnswerSummary Is their a way to track how many times a video has been viewed within an answer?Content I created an Answer on the customer portal and included 2 videos within t…Dorothy Norman 27 views 1 comment 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service -
How to export multiple grid values in separate excel sheet in FR ReportSummary Export multiple grid values in excel sheet by one grid in one sheet FR ReportContent Dear All, I have created a FR report using more than 5 GRID. As per my requi…user11018780 27 views 2 comments 0 points Most recent by user11018780 Reporting & Analytics for B2C Service -
Create a custom script in reportSummary Modify URL in the report data cellContent Hi, I've been reading about custom script in the report. I followed through online documentation and able to get the va… -
answers viewed data from iFrame?Content Does anyone know if it's possible to collect answers viewed data from a report that runs in an iFrame? I have a situation whereby you login to site x (not an Ora…User_2025-02-01-08-46-19-550 36 views 5 comments 0 points Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 71 views 0 comments 5 points Most recent by User720640-Oracle Reporting and Analytics for SCM -
Field that tracks customer closed incidentsContent Hello, I'm trying to report on all incidents closed by customers, what table and field stores this data? Thanks in advanced! JustinUser_2025-02-03-17-08-02-219 36 views 3 comments 0 points Most recent by JLFolkman Reporting & Analytics for B2C Service -
Using a date prior to 1970 in REST api callSummary calling report with a date prior to 1970 failing via REST api, eror that it is not a valid date/time formatContent We have made a report that is to be called via…User_2025-02-04-06-43-57-835 35 views 0 comments 0 points Most recent by User_2025-02-04-06-43-57-835 Reporting & Analytics for B2C Service -
Expression syntax errorSummary keep getting expression syntax errorContent Hi I an trying to get a report with the interval (day) in one column and the the individual incident queues and their…User_2025-02-01-07-02-31-666 39 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Activities not appearing in Interaction historySummary Task of type 'Call' not appearing in Interaction historyContent Dear Team, I would like to understand more about this interaction history tab. as I understand it… -
Need SQL script for Return sales orders information in Oracle ERP cloudSummary Need SQL script for Return sales orders information in Oracle ERP cloudContent Hi Experts,I am looking for sql code to Return sales orders information in oracle …User_2025-02-03-23-55-22-632 77 views 2 comments 2 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Agents AuditContent Hi, We've been asked to produce an audit of agents creation, edits and deletions. * Profile Type * First Name * Last Name * Collar Number * Login * Attributes/Ac…User_2025-02-03-19-49-57-702 40 views 5 comments 1 point Most recent by Joe P. Reporting & Analytics for B2C Service -
remove no value calculated rowsSummary when creating a calculated column - exclude rows that return "No Value"Content Hello, I'm creating a calculated column by searching for a substring within anothe…User_2025-10-31-01-08-51-703 59 views 4 comments 0 points Most recent by User_2025-10-31-01-08-51-703 Reporting & Analytics for B2C Service -
Meaning for Sales-CRM Pipeline fact "# of New Opportunities"Summary I am looking for the definition of "New" for the Sales-CRM Pipeline fact "# of New Opportunities".Content When pulling this Fact into my analysis today, I am see…User_2025-01-28-01-29-38-878 39 views 2 comments 2 points Most recent by User_2025-01-28-01-29-38-878 Reporting & Analytics for Sales -
Syntax/ expression guideContent Hi! Is there any guide/tutorial with examples with all the syntax and expressions available in reports? Thnx!User_2024-12-17-19-53-13-615 49 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Drilldown level error in reportsContent Hi All, I have created a report with drilldown level.When I open the report and click the drilldown it shows as reports errors. It seems that it is an argument m…Shaheela 22 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Eliminating duplicates in a column but not rowsSummary Attempting to remove duplicates revenue values because it throws off the totalContent I'm using two custom objects that are related to each other. One object is …User_2025-02-03-18-15-20-995 47 views 3 comments 0 points Most recent by Colby Ross Reporting & Analytics for B2C Service -
replacing image with valueContent We would like to replace the 'checkmark' in the standard 'Survey Responses by Contact' report with a value. The reason being that the checkmark is an image and w…User_2024-12-17-19-38-18-061 38 views 2 comments 1 point Most recent by User_2025-02-03-22-16-06-242 Reporting & Analytics for B2C Service -
BUI - custom report for archived incidentsSummary Because the BUI does not allow for Archived Incidents object, need custom reportContent Has anyone come up with a solution to view the threads of an archived inc…User_2025-01-31-02-50-15-254 28 views 1 comment 0 points Most recent by User_2025-01-31-02-50-15-254 Reporting & Analytics for B2C Service -
Problem with joinsContent Hello, We are trying to create a report that brings back all of the client incidents in a specific time frame, by product and client. We are joining on tables SL…User_2025-02-03-23-57-10-720 30 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
サンプル・レポートを活用しましょう。Summary オラクルや他のお客様の作ったレポートを自社でも使ってみませんか? Content オラクルのHCM Cloudでは「標準レポート」や「標準KPI」を提供する代わりに、「サンプル・レポ… -
Alternative to Publishing or Emailing Scheduled ReportsContent Hi all, Since Service Cloud does not provide method to perform batch jobs, we have created a report containing a script and scheduling it to run nightly. Since t…JoshLong 26 views 2 comments 0 points Most recent by Colby Ross Reporting & Analytics for B2C Service