Category 276
Discussion List
-
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…Emily S. 37 views 5 comments 0 points Most recent by Ryan Schofield-122326 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…Jeff Booze-115129 16 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…chidambaram CT 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 -
Exporting results from Report Management?Content Is it me or is this not possible? Is there a way to ADD these options to the screen? Version FEB 2015Joe P. 14 views 6 comments 0 points Most recent by Kenny Tietz-23935 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…Bastiaan van der Kooij 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…Vanessa 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…Emily S. 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…Emily S. 16 views 2 comments 0 points Most recent by Dietrik -120086 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…Phil Shisbey 25 views 5 comments 1 point Most recent by Pramod Vasudeva Murthy-80436 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…Chaitanya Jaggu-119673 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 …Matt Miller-114807 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…Matt Miller-114807 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…Mike Kramer 24 views 2 comments 0 points Most recent by Dietrik -120086 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…Jeff Booze-115129 27 views 4 comments 0 points Most recent by Jeff Booze-115129 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…Arturo Zindel 15 views 5 comments 0 points Most recent by Sasi Gudimetta-124670 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 …Paul Howard-114372 26 views 6 comments 0 points Most recent by Dietrik -120086 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…Robert Graham 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 25 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…Sean Rosenberg-122486 38 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 …Andrew Wooster-114803 32 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…Pramod Vasudeva Murthy-80436 32 views 8 comments 0 points Most recent by Pramod Vasudeva Murthy-80436 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 inJeff Booze-115129 32 views 4 comments 0 points Most recent by Jeff Booze-115129 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…Kevin Kennedy-117709 35 views 4 comments 0 points Most recent by Kevin Kennedy-117709 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…Tamika Mitchem 57 views 1 comment 0 points Most recent by Richard Keevil 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…BishnuPaudel 23 views 3 comments 0 points Most recent by Dietrik -120086 Reporting & Analytics for B2C Service