Reporting and Analytics
Discussion List
-
products with no incidentsContent I'd like to get a report that list products that do not have any related incidents. Any ideas?Kim Dante 22 views 4 comments 0 points Most recent by Kim Dante Reporting & Analytics for B2C Service -
Show Errors from Custom Report ScriptContent Is there any way to see the errors generated by a custom report script somewhere? I saw a few posts that said this was possible, but I couldn't tell if they were…user3511667 24 views 0 comments 2 points Most recent by user3511667 Reporting & Analytics for B2C Service -
Adding custom text above search fieldsContent Hello dears, We're creating a custom Contacts search report and we were wondering is it possible to include a text above the search fields when searching? Basica…Hanna Abi Akl 24 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
How to exclude holidays from a report showing a weekly / daily average volume of incidentsContent I have a report which shows the average number of incidents per day. I need a way to write the daily average column so that it excludes days which are configured…User_2025-01-28-05-44-49-224 30 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Definitions and functionsContent Hey Ya'll! So I am new to this, so please forgive me if this is a simple question that I cannot figure out. The definition of our chat service level states: sum(…User_2025-02-03-19-20-35-072 36 views 0 comments 1 point Most recent by User_2025-02-03-19-20-35-072 Reporting & Analytics for B2C Service -
Best way to count casesContent Hello, I'm a little stuck here... Can someone tell me what the best way to count the number of cases would be in Oracle? I've found about 10 different ways, each…User_2025-02-01-08-40-26-447 37 views 5 comments 0 points Most recent by User_2025-02-03-21-53-19-701 Reporting & Analytics for B2C Service -
Report to list accounts assigned to incident and chat queuesContent We have quite a few profiles and there is some overlap on incident queue or chat queues assigned to profiles. As staff turns over, I want to make sure we never e…User_2025-02-01-08-49-49-892 17 views 5 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Dynamic report based on the dayContent If want to create a report with dynamic filter. For example, lets take incident.created date field. If I run the report on monday, then report should fetch incid…User_2025-02-03-16-53-11-440 30 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Scheduled Report Export FormatsContent When you create a new schedule for a report, the drop down menu lists the export file formats available. However, when trying to create a report that includes th…Joe P. 15 views 3 comments 0 points Most recent by Edson Junior, Oracle Reporting & Analytics for B2C Service -
Typing Expressions so Slow in Windows 10Content Does anyone else experience the slowness of typing in Column Expressions in a report using Windows 10? The longer the expression gets the slower it becomes. Writ…User_2025-02-03-19-30-01-975 27 views 2 comments 2 points Most recent by Chris Martin-125966 Reporting & Analytics for B2C Service -
Less than date filter including "No Value"Content I'm creating a report to show incidents with a due date in the current week and prior. I was able to accomplish this with using the expression as the date, opera…User_2025-02-03-19-37-18-427 28 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Filtering for last 12 hoursContent Hello, I am working on a pretty basic report that tells me which cases came in during the last 12 hours. I am using the Incidents.Created field for the date/time…User_2025-02-01-08-40-26-447 23 views 9 comments 0 points Most recent by Kenny Tietz-23935 Reporting & Analytics for B2C Service -
Scheduling Drill Down Reports?Content Hi all, Is there any way to schedule reports that have drill downs, so that all of the report information is sent on the schedule? I have a repot with two layers…User_2025-02-01-08-40-26-447 16 views 2 comments 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service -
Invalid object name: rulesContent How to query the rules table in RightNow Oracle Service Cloud? The data dictionary lists a "rules" table. I tried querying it with The Connect Object Explorer bu…User_2025-02-03-18-52-22-449 25 views 5 comments 1 point Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service -
Report to calculate Trend for inflow, outflow and backlog for a specified time periodContent Hi, Could someone please help in calculating trend for inflow, outflow and backlog of cases for a specified time period. Thanks in Advacne Regards Chaitanya Vers…User_2025-02-03-20-56-19-937 29 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Customer Portal Login StatisticsContent Hi everyone, Are there any out-of-the-box reports to show Customer Portal sign-ups, login statistics, etc.? I have searched the entire Reports Explorer and have …User_2025-02-01-08-41-04-877 42 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Day of Week Report - Removing Alphabetical OrderingContent Hi everyone, I have attached a picture of a custom report I have built to show the number of chats requested, by day of the week, for any date range. However, wi…User_2025-02-01-08-41-04-877 28 views 7 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Updating/Removing Categories - Any Impact on Reporting History?Content We are getting requests to update/remove some of our Program/Dept categories and want to ensure that this will not cause any issues with reporting down the road.…Joe P. 24 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Cannot Open Opportunity from ReportContent I've been banging my head against the wall for a couple of days on this one. I have a couple of reports I created a while back that show a table of our opportuni…User_2025-02-03-18-15-20-995 24 views 2 comments 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service -
Chat Average Time to AbandonContent I see where historical reporting provides Average wait time to get an answer, but we would like to see Average wait time to abandon. This would be a date differe…User_2025-02-01-08-49-49-892 27 views 4 comments 0 points Most recent by User_2025-02-01-08-49-49-892 Reporting & Analytics for B2C Service -
Alternative to using 'FIRST' and 'LAST' in filtersContent Hi there - I'm wondering if someone might be able to help me with this. I have two incident 'types' - call them 1 and 2. I need a report that shows me only conta…User_2025-02-03-18-15-18-780 26 views 5 comments 0 points Most recent by User_2025-02-03-19-31-14-086 Reporting & Analytics for B2C Service -
Scripts in ReportingContent Is there an easy way to find out which (custom) reports have scripts? Looking into the Data dictionary it says the table Scrips (ac_scripts) (id 168), but I can …Chris van Es 46 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Multiple drill-down levels in your report from the same outputContent I'm looking to create a report that has a summary, and then when you click on items in the summary it launches into different drill downs. So: Product Number of …User_2025-02-03-16-56-48-238 26 views 6 comments 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service -
Filter out contact list by disposition of last incidentContent Hello, I’m completely new to Rightnow and don’t have a development background. I’m working for a charity and slowly picking things with a lot of help from this f…User_2025-02-03-18-51-09-741 14 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Calculate Last Assigned to first Changed StatusContent Looking at the inc_performance.intv_type I only can find the "Last Assigned to Final Resolve". But not Last Assigned to Status changed. I like to calculate the t…Chris van Es 24 views 9 comments 1 point Most recent by Danette Beal Reporting & Analytics for B2C Service -
External Screen Pop Port Field MissingContent Hi, I am looking to create a report that shows what values we currently have assigned for each agents External Screen Pop Port. The field shows up in the Account…eyespike1 28 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Filter Not Using IndexContent Hello All - I have a report containing a single table (thread) and a single required runtime-selectable filter (threads.entered >= ****). Analyzing the report re…User_2025-02-03-21-53-53-210 36 views 6 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Create incident from "Social Monitor" report and assign productContent When we create an Incident from the "Social Monitor" report, there is not a Product assigned. Can these reports be edited or changed to accomplish this or do we …User_2025-02-01-08-41-00-820 32 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
UX Lab Tour at Oracle HeadquartersSummary UX Lab Tour at Oracle HeadquartersContent Being able to tour the Cloud UX Lab while at OpenWorld is an exceptional encounter! Glimpsing the forthcoming adventure… -
How to embed logs in reports?Content Hi All, I would like to embed logs inside reports. I have a standard report by name - Web Visits and has come custom script embedded inside it. Would like to pri…User_2025-01-30-19-06-33-073 33 views 8 comments 0 points Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service