Reporting and Analytics
Discussion List
-
Show list of custom fields created by a certain account?Content If I want to know what custom fields have been created by a particular account (this value can either be hardcoded or supplied as filter), what tables will I hav…Nisar 28 views 6 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Incident Summary SearchSummary How to exclude Auto Responses and SmartAssistant in search resultsContent We have created reports to search by incidents.search_thread , however this seems to se…Tod 71 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
HR HelpDesk and BICC ObjectsSummary Does BICC objects (View Objects) for extracting data from HR helpdesk exist?Content Hi all Is there anyone who knows the answer to three following questions: 1) … -
Report styling tip for row numberSummary A styling tip to get your row number match other stylesContent This is just a styling tip that I would like to share on how to get a row number to match your rep…Sebastiaan Draaisma-122509 38 views 3 comments 4 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service -
Users that have not logged inSummary Tracking users that have not logged into the OSvC ClientContent Hello, I'm trying to create a simple report that will show a user's name and whether or not they'…kerry walker 85 views 23 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
wrong forum, please delete.Version 18.bPavel Kartuz 34 views 0 comments 0 points Most recent by Pavel Kartuz Reporting & Analytics for B2C Service -
Disable Add New optionSummary Disable Add New optionContent I have report linked to contact workspace tab.(Ref Screen Shot below) I want disable "Add new" option if report contains one record…User_2025-02-03-16-53-11-440 37 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
How to remove the ".invalid" from email signatureSummary email signatureContent I would like to find way to remove the '.invalid' in the email signature for the contacts. Help Any one?User_2025-02-03-21-27-12-392 27 views 2 comments 0 points Most recent by User_2025-09-05-00-11-37-622 Reporting & Analytics for B2C Service -
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 215 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