Category 276
Discussion List
-
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 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 49 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 28 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 16 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 26 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 37 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 33 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
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
-
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 Reporting & Analytics for B2C Service
-
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…Kenny Tietz-23935 141 views 0 comments 19 points Most recent by Kenny Tietz-23935 Reporting & Analytics for B2C Service -
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 Reporting & Analytics for B2C Service
-
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 Reporting & Analytics for B2C Service
-
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 Reporting & Analytics for B2C Service
-
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…User_2025-02-03-19-30-01-975 84 views 1 comment 11 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service
-
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…Vignesh Nagarajan-126051 22 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
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 Reporting & Analytics for B2C Service
-
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 …User_2025-02-03-18-15-18-780 46 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
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…Jeff Elser-Oracle 51 views 2 comments 4 points Most recent by User_2025-02-03-20-10-42-447 Reporting & Analytics for B2C Service -
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…Jeff Elser-Oracle 62 views 2 comments 4 points Most recent by User_2025-02-03-20-10-42-447 Reporting & Analytics for B2C Service
-
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…User_2025-02-03-16-11-55-768 66 views 10 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Sorting Reports by YearContent Hello dears, We have a custom incidents report that needs to be sorted by latest incident created on top. I've clicked the small arrow next to the creation date …Hanna Abi Akl 23 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
A Way to Add Notes to Custom ReportsContent We have a LOT of reports that have been customized. Is there a way to add notes about the report (why it was created, when, who requested and other pertinent inf…User_2025-02-01-08-18-48-897 36 views 5 comments 0 points Most recent by User_2025-02-01-08-18-48-897 Reporting & Analytics for B2C Service
-
Pop up report with Quick Search abilityContent We use popup report by URL for integration with CTI. CTI call a URL with parameters of report id and contact phone number, which is defined as a filter in the re…User_2025-02-01-08-56-24-846 15 views 0 comments 0 points Most recent by User_2025-02-01-08-56-24-846 Reporting & Analytics for B2C Service
-
Need a way to exclude holidays from my weekly incident volume averageContent I have a custom report that contains these columns : Week start: date_group(stats.stat_date, $date_grp_param) Total chats: sum( stats.new_incidents ) Daily Avera…User_2025-01-28-05-44-49-224 26 views 0 comments 0 points Most recent by User_2025-01-28-05-44-49-224 Reporting & Analytics for B2C Service
-
Report to show customers new to ChatContent Hi everyone! Can anyone think of a way to report on customers that are new to chat? We currently do not require that our users log in to our site (that will be c…User_2025-02-01-08-18-48-897 34 views 4 comments 1 point Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Number of Incidents Created by Source UniqueContent I'm needing to create a report that counts the number of incidents created by source. The sources are AAQ, Phone and Email. BUT the email is not using the techma…Tod 33 views 2 comments 0 points Most recent by User_2025-02-03-19-31-14-086 Reporting & Analytics for B2C Service
-
Display Organizations based on the total number of open casesContent I would like to display Organizations that have 5+ open cases on a report. Is this possible? Right now it displays all the Organizations based on my other filter…JLFolkman 13 views 1 comment 0 points Most recent by User_2025-02-03-19-31-14-086 Reporting & Analytics for B2C Service
-
All threads for an incident in a single line - with a twist!Content Background: Someone deleted a contact which in turn deleted the incidents and threads associated with it. You've got a choice of paying OCS to restore the data o…Chris Clifton 44 views 5 comments 3 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Like Operator in Report Filter not working properlyContent Hello dears, I am facing a similar issue to this post: https://cloudcustomerconnect.oracle.com/posts/871dfd2de0#170712 whereby I need my search filter to return …Hanna Abi Akl 25 views 3 comments 0 points Most recent by User_2025-02-03-19-33-02-045 Reporting & Analytics for B2C Service