Reporting and Analytics
Discussion List
-
Show corresponding filter valueSummary Show corresponding filter valueContent Hi, I have 2 filters ID & Name. User filter the report either by ID or Name. I show filter value in text item ((filter nam…User_2025-02-03-16-53-11-440 35 views 2 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
How to show decimal places in 'average' column calculation?Summary Using the 'average' calculation is rounding, and I don't want it to.Content Hi everyone, I am trying to use "Edit Calculations" on a report column to get an aver…Mig Ponce-121584 30 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Changing date in report column from dd/mm/yyyy to dd/mm/yySummary Change from 4 digit year to 2 digit yearContent In Edit Definition I have tried date_format(fieldname,'DDMMYY') but it stopped showing the date and just repeated… -
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…Alberto Romani-Oracle 56 views 7 comments 1 point Most recent by Alberto Romani-Oracle Reporting and Analytics for SCM -
Report to pull Accounts that doesnt have any associated opportunitiesSummary Report to pull Accounts that doesn't have any associated opportunitiesContent HI team, we are in the process of cleaning our Accounts module in Sales cloud, so i…Sharath Shanker 64 views 11 comments 2 points Most recent by Sharath Shanker Reporting & Analytics for Sales
-
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
OTBI CX Reporting - Best PracticesSummary OTBI CX Reporting - Best PracticesCode Snippet OTBI CX Reporting - Best PracticesMadhava Reddy-Oracle 86 views 3 comments 6 points Most recent by Adam Liu Reporting & Analytics for Sales
-
Date group formatting by week.Content Hi, I am grouping data into reporting weeks by using the syntax below: date_format(transactions.created,'Week: WW MONTH YY'). This is displayed as "Week: 34 Augu…User_2024-12-17-19-49-19-019 52 views 6 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service
-
Filter "To" Email Addresses in Forward IncidentSummary Filter "To" Email Addresses in Forward IncidentContent Is it possible to filter the list of email addresses that are displayed when forwarding an incident? For e…JoshLong 23 views 3 comments 2 points Most recent by Just Rhianna Reporting & Analytics for B2C Service -
Difference between Duration and Total PeriodSummary Difference between Duration and Total PeriodContent Hello, Can you help me understand the difference between Chat duration defined as if(chats.state=5, date_diff…User_2025-02-03-17-38-42-482 31 views 3 comments 0 points Most recent by User_2025-02-03-17-38-42-482 Reporting & Analytics for B2C Service
-
Remove field in exported reportSummary Remove fields in exported reportContent I have 4 fields in my report. When I export the report, I want remove 1 fields and show 3 fields in the exported report.(…User_2025-02-03-16-53-11-440 17 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
Reporting on NotesSummary How can we report on notes created in Sales Cloud?Content Is it possible to report on the notes created against an opportunity or an account? Example attached Th…Cyrille Saulnier-Oracle 37 views 2 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Enabling the User to Edit Reports Created by other USerSummary Enabling the User to Edit Reports Created by other USerContent Hello , I need to enable a user to edit reports for SCM created by other user i created a Custom R…Ali Essam El-Bandrawy 46 views 2 comments 0 points Most recent by Ali Essam El-Bandrawy Reporting and Analytics for SCM -
SR Feedback featureSummary Any ways to request feedback from Customers?Content Do we have any feature to request feedback for SRs we worked with customers? If no, do we have it in near roa… -
Removal of duplicate emails for a contactSummary Script to remove emails with .00XXContent Hi All, I've added the below script in one of my report to delete duplicate emails Scenario: email_alt1 is valid and em…User_2025-02-04-23-27-31-855 95 views 1 comment 0 points Most recent by User_2025-02-04-23-27-31-855 Reporting & Analytics for B2C Service
-
Sort Incident Menu Custom FieldSummary Sort by Menu Order Option DisabledContent Hey all, I have a custom field in Incidents that is of the menu datatype and the menu items are being pulled from a men…JoshLong 32 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
No result shown in the audit reports for the contactSummary No result shown in the audit reports for the contactContent No result shown in the audit reports for the contact despites of the all audit setup done So why when… -
Custom attribute of OOTB object in BICCCSummary Custom attribute of OOTB object in BICCCContent Issue detail, In BICCC, I see actual table column name instead of the object attribute name. Any idea how to fix … -
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 255 views 3 comments 10 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Proactive Chat Offer Statistics #3033Content Is there a way to filter Proactive Chat Offer Statistics #3033 to show the originating webpage? I know how to distinguish the page using a custom field once an i…Kim Dante 27 views 1 comment 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Problem with adding Custom Reports on Report DashboardContent Hello I'm using February 2016, and I've been trying to add two custom reports on Report Dashboard, referring to the following Answer; https://cx.rightnow.com/app…Megumi Nishikawa 47 views 2 comments 0 points Most recent by User_GIUF2 Reporting & Analytics for B2C Service -
Report based on Virtual Table- Real time data update and Current Record ContextSummary Updates to External Data report based on Virtual TableContent Good Day, Can we fetch the current record context from a report based on virtual table (external da…User_2025-01-31-15-38-44-499 53 views 1 comment 0 points Most recent by Scott Harwell Reporting & Analytics for B2C Service
-
Report Needs to Include Updated Messages, New Messages and %s and Real TimeSummary Updated Messages, New Messages and %s Percentages for queues - Real TimeContent I'm trying to develop a report that will give the 'Queues' current volume, volume…User_2025-02-01-07-43-22-355 30 views 0 comments 0 points Most recent by User_2025-02-01-07-43-22-355 Reporting & Analytics for B2C Service
-
Embedded URL ReportSummary How to show the file path of the attached file in an incidentContent Hi Everyone, I've working in my reports and i was able to show the attachments on each incid…Jovit Manalaysay 22 views 0 comments 0 points Most recent by Jovit Manalaysay Reporting & Analytics for B2C Service
-
Opportunity Sales Stage NameSummary How to retreive previous "Sales Stage Names"?Content Hello, I have a requirement in which I need to highlight all "Sales Stage Names" that have been assigned to …User_2025-02-04-17-55-40-189 40 views 6 comments 0 points Most recent by User_2025-02-04-17-55-40-189 Reporting & Analytics for Sales
-
Filter by Territory - OTBIContent Hi all, I have a couple of analysis for users with Sales Manager role. I need to add the "My Territory" filter to one of them and the filter "My Territory hierar… -
R20 Direct Database Query decommisionSummary Create Data modelContent We have a Deal Registration analytics done via Data model due to the Submitted Date field SUBMITTED_DATE is formatted as DATE only. Whil…User_2025-01-28-17-45-38-966 35 views 2 comments 0 points Most recent by Karina Ogata Reporting & Analytics for Sales
-
Real Time Reporting - Incidents Received, Resolved, Longest time in QueueSummary Real Time Reporting - Incidents Received, Resolved, Longest time in QueueContent We've been tasked with creating Real Time Reporting (or as close to real time as…User_2025-02-01-07-43-22-355 67 views 3 comments 1 point Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service