Reporting and Analytics
Discussion List
-
Show Percentages of crosstab column Total?Summary Need help creating a view that show trending over time (daily, weekly etc) in the % split of our Product IDs..Content I know this is possible but seem to be unab… -
Creating a custom report with a date range in the outputSummary 1-6 days passed SLA, 7-10 Days passed SLA, 11-14 Days and 15 or greaterContent Hi friends, I am trying to create a report with incident data where I am checking …NJ 44 views 3 comments 0 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service -
Schedule a half month reportSummary schedule a report that shows 16th to end of monthContent Hi, does anyone have an idea if it is possible to schedule a report based on hard-set half month? So the…User_2025-02-03-16-51-39-328 34 views 0 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Passing filter value to search report dynamically from workspaceSummary Passing filter value to search report dynamically from workspaceContent when we open a search report from a workspace, i want to pass a filter value dynamically,…SumanB 56 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service -
Exceptions don't work after the script processing has runContent How do I make exceptions work when I have a custom script processing the rows? Should it still work because I can't make it work So let's say I have a column tha…King Jack 60 views 0 comments 1 point Most recent by King Jack Reporting & Analytics for B2C Service -
date_add but only weekdaysSummary Want to use date_add, but only using weekdaysContent We have a variable that adds different numbers of days to the created date depending on the category to give…Ineke Clewer 37 views 0 comments 0 points Most recent by Ineke Clewer Reporting & Analytics for B2C Service -
Saved Prompt Values not working (Apply Saved Customizations)Summary Need ability to have individual users review Analysis based on their prompt value selections and be able to save those values so they don't have to make prompt s…Brannon B 32 views 1 comment 0 points Most recent by Just Rhianna Reporting & Analytics for B2C Service -
group search resultsSummary OKA I try to make a grouping of results by date and IDContent Hi, for an OKA customer im working on a report that groups searches by contact iD, by datetime. I g…Sjoerd Spring in 't Veld-145555 34 views 0 comments 0 points Most recent by Sjoerd Spring in 't Veld-145555 Reporting & Analytics for B2C Service -
Report join should display info from Primary & Secondary tableSummary Report join should display info from Primary & Secondary tableContent I have contact table with primary employment detail and custom object secondary employment …User_2025-02-03-16-53-11-440 38 views 4 comments 0 points Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service
-
Report including Incident created, status changed and previous status changed date columnsSummary Help required with Custom Script to enable date in status reporting requirementContent Hi, 1. I have built a report that uses the Incidents table to get the refe…Craig Hevey 89 views 1 comment 2 points Most recent by User_2025-02-03-18-42-00-650 Reporting & Analytics for B2C Service
-
how to get the number of chats by siteContent We offer customers to start chat from customer Portal and brand website (by CCL link), i would like to identify how many chat coming from our custhelp pages and …Ajay Yadav-140866 31 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
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 37 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 33 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… -
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 54 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 24 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 32 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 20 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
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 99 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 35 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
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 29 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 51 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 56 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 33 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 23 views 0 comments 0 points Most recent by Jovit Manalaysay Reporting & Analytics for B2C Service
-
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 71 views 3 comments 1 point Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Reports Alignment on DashboardContent Hello, Can someone please share tips for aligning reports on dashboard? i have tried multiple ways but it's really annoying to just fit all reports without scrol…User_2025-02-03-20-08-55-527 73 views 3 comments 0 points Most recent by Nir Wissotzky-Oracle Reporting & Analytics for B2C Service
-
Interval Type - Menu DescriptionsSummary Looking for full descriptions for menu itemsContent Hi. I'm looking for a published list with FULL descriptions/example for each of the Menu Items under Interval…Marissa Gonzales 32 views 5 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
How to remove the highlight on the first line of a reportContent There may be an obvious answer to this petty annoyance.. but here goes...! I have some nice reports with exceptions that colour lines of data based on service le…JBaxter 41 views 6 comments 0 points Most recent by User_2025-02-05-02-13-35-681 Reporting & Analytics for B2C Service -
First call resolution report (Basic)Content Hello everyone, I'm trying to write a report which will show me in very basic terms the first call resolution. To do this I want to create a report with three co…User_2025-02-01-08-44-34-192 41 views 13 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service