To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
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… -
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 17 views 2 comments 0 points Most recent by User_2025-02-03-20-16-45-224
-
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
-
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…
-
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 …
-
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…
-
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.… -
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
-
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
-
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 16 views 5 comments 0 points Most recent by User_2025-02-03-19-31-14-086
-
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 … -
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 28 views 6 comments 0 points Most recent by User_2025-02-03-20-16-45-224
-
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…
-
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…
-
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… -
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…
-
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 …
-
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
-
Formula to subtract one column total from another column not working if one is zeroContent I want to create a formula that calculates chats offered minus chats abandoned inUser_2025-02-01-08-49-49-892 32 views 4 comments 0 points Most recent by User_2025-02-01-08-49-49-892
-
How You Can Contribute to the Analytics CookbookContent Do you like the Analytics Cookbook? Are you picking up some new skills? Do the use cases have you thinking about new reporting possibilities you previously had n… -
Filter out duplicate reference numbersContent We have a report that displays the Reference Number, status, created by, assigned to, details (Custom Field) and date created. We have run into a situation where…User_2025-02-03-17-15-57-451 36 views 4 comments 0 points Most recent by User_2025-02-03-17-15-57-451
-
Importing Analytic Cookbook RecipesContent Hello, I'm having issues importing the xml files from the Analytic Cookbook Recipes. I keep getting the attached error. Is there something that I'm missing? Vers…User_2025-02-03-22-35-27-600 59 views 1 comment 0 points Most recent by User_2025-02-01-08-58-47-501
-
Filtering out old recordsContent hi all, I am stuck with creating a report based on data on a custom object. The custom object is related to opportunities table where we keep the history every t…User_2025-02-03-20-11-07-340 24 views 3 comments 0 points Most recent by User_2025-02-03-20-16-45-224
-
Top Keywords Trend - Analytics Cookbook RecipeContent Top Keywords Trend Show the trend of todays most used keywords Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Adv…
-
Need Customer's email instead on Full Name in chats_rtContent Hi, We have a requirement of presenting the email address instead of the full name in the Chats - Real Time report. Kindly let me know how I can do that, since t…
-
Record Limit 10000Content Is there a way when pulling reports to set my Record limit to a higher setting? I'm really wanting to put this record limit to 50,000 or even 100,000 per page...…User_2025-02-03-18-58-47-399 50 views 3 comments 1 point Most recent by User_2025-02-01-08-18-48-897
-
Setting the conditional formatting for a whole row rather than just a particular cellContent Is it possible to use conditional formatting in a report to highlight an entire row if a column in a row has a particular value? It seems like I can only format …
-
KCS Answer Citations By Author - Analytics Cookbook RecipeContent CITATIONS BY AUTHOR Knowledge-Centered Service (KCS) Author: Jeff Elser Difficulty rating: (Basic) Target persona: Authors, Managers Ingredients: 3 Tables (answe… -
KCS Answer Citations By Group - Analytics Cookbook RecipeContent CITATIONS BY GROUP Knowledge-Centered Service (KCS) Author: Jeff Elser Difficulty rating: (Basic) Target persona: Authors, Managers Ingredients: 4 Tables (answer…
-
Analytics/Reporting Functions With ExamplesContent Hi, I have been creating reports in the RightNow CX by using the functions but most of the times its hit & try because I can’t find list of all functions with th…