Category 276
Discussion List
-
Select Join - allow different type of joinsContent Looking at https://cloudcustomerconnect.oracle.com/posts/66caf8788a - wondering if this was put in or there is a workaround? I currently want to pull all survey …DigitalWMP_21 24 views 3 comments 0 points Most recent by Scott Harwell Reporting & Analytics for B2C Service
-
Creating a report for Custom FieldContent Dear All, I am looking for detailed information, if anyone can share, i have a requirement which goes like this: Similar to Status Field in incident Workspace ( …Rajesh Singh-61723 11 views 1 comment 0 points Most recent by Bastiaan van der Kooij Reporting & Analytics for B2C Service
-
Letting Users See Attachments from a ReportContent Hi all, We have a daily report wherein customers can send in screenshots to us showing a bug in our game. We have this report auto-email interested internal user…Brandon Kreines 18 views 2 comments 0 points Most recent by Brandon Kreines Reporting & Analytics for B2C Service
-
count combined with ifContent Hi all, maybe I am thinking too complicated, but there is a challenge I have currently no solution for: I am trying to count records with an if condition. That i…Kai 60 views 1 comment 0 points Most recent by Satish Iyer-125765 Reporting & Analytics for B2C Service
-
Agent Reports for Incidents and Chat created today by hourContent Does anyone know if there is a report available that can show me: 1. Incidents & Chats that were created (Today) by hour. 2. Which agent picked up/resolve the in…Damian Meddings 28 views 1 comment 0 points Most recent by Santosh -118458 Reporting & Analytics for B2C Service
-
Incident Counts for Historical Reporting ChangingContent I'm scratching my head over here. I have a very basic report (definition image attached) that I have been using to look at month over month trends since we start…Chris Hobson 14 views 3 comments 0 points Most recent by Chris Hobson Reporting & Analytics for B2C Service
-
Limit the number of records to 5 in a reportContent Hi All, I am trying to limit a report such that it should show only 5 records. I have a custom object called bill with bill date, bill number etc as fields. My r…Jaya Krishna Sumanth Ch 39 views 2 comments 0 points Most recent by Jaya Krishna Sumanth Ch Reporting & Analytics for B2C Service
-
meaning of threads.seq - and howto filter on itContent Hi all, I've got a small challenge: I try to filter out the 1st contact of a customer within an incident, and my intention is to use the threads.seq field. My as…Kai 32 views 5 comments 0 points Most recent by Bastiaan van der Kooij Reporting & Analytics for B2C Service
-
Top align rich text in custom reportContent Hi, I am facing problem in making rich text top align in custom report. In custom report, if you use plain text you will see it all run together but if you are u…Baljeet Singh-119399 30 views 2 comments 0 points Most recent by Baljeet Singh-119399 Reporting & Analytics for B2C Service
-
How can I create a report that shows all answers with no review date?Content I'm trying to set up a report that shows all public answers in our Knowledge Base that do not have a review date set. I would have thought that a filtering on an…Gary Fisher 29 views 2 comments 0 points Most recent by Gary Fisher Reporting & Analytics for B2C Service
-
Clickstream Report by Contact for Workspace ReportContent Hello All, I am looking to use the standard Clickstream report that we have and I want to be able to pull the Browser and Version for each user into a separate r…Emily S. 24 views 5 comments 0 points Most recent by Bastiaan van der Kooij Reporting & Analytics for B2C Service
-
In a nested rollup, display average of lowest levelContent I have a chat report that I have rolled up by Agent and then under each agent, I did a 2nd rollup by the Interval type, So I have two areas, Time as Lead Agent a…Vivian Tedford-87196 16 views 1 comment 0 points Most recent by Bastiaan van der Kooij Reporting & Analytics for B2C Service
-
Sumifs/Countifs Function?Content Hi there! I am trying to count something in a report that meets criteria in two different text fields. For example, the formula I would use in Excel would be: co…Genevieve Gollan 54 views 2 comments 0 points Most recent by Satish Iyer-125765 Reporting & Analytics for B2C Service
-
Errors Downloading Cookbook zip filesContent Hello, I tried downloading three different files (Top Keyword Trend, Answer Effectiveness and Answers Not Used) on Chrome and IE on two different computers - one…Jasmin Ibrahim 22 views 2 comments 0 points Most recent by Barrilito van Dijk Reporting & Analytics for B2C Service
-
Report to show number of answers proposed by an accountContent Hello , There is scenario where i am trying to create a report which shows the number of incidents solved, unresolved and answer proposed by a particular agent/ …Priyanka Tiwari-124500 23 views 1 comment 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Trying to count field with text as a data typeContent Hi there! I'm fairly new to the analytics side of Oracle and I need some help with functions. Specifically, I'm trying to count the number of entries with a spec…Genevieve Gollan 34 views 2 comments 0 points Most recent by Genevieve Gollan Reporting & Analytics for B2C Service
-
Reporting totals in circle LEDContent Hey guys and gals! So I have had a month since MSE and forgot so much. I tried to rewatch the videos but my mind goes blank lol. My problem is.. I want to just s…Terri Marbry 25 views 4 comments 0 points Most recent by Terri Marbry Reporting & Analytics for B2C Service
-
There has been an error with your request.Content So I have the code has shown below. One column in this report was created by going in to design the report in the console, going to Computed Fields, clicking on …DigitalWMP_21 23 views 5 comments 0 points Most recent by Rajan Davis-126711 Reporting & Analytics for B2C Service
-
What are the various attributes in transactions table for a status change?Content So I have the below from the transactions table. I see that Attribute 1 is changed to the value of 3 when I choose "Pending Information" for the status. The valu…DigitalWMP_21 22 views 2 comments 0 points Most recent by DigitalWMP_21 Reporting & Analytics for B2C Service
-
Averages not working as expectedContent Hi, I'm running two sets of ROQL queries as follows: SELECT Incident.Queue.LookupName as QUEUE, AVG(date_diff(CreatedTime,'2017-05-31 21:10')/86400) as 'AVG' FRO…DigitalWMP_21 16 views 1 comment 0 points Most recent by DigitalWMP_21 Reporting & Analytics for B2C Service
-
Add button/image to Quick Search report to Add New Contact/Incident, etcContent Hi, Our agents heavily use the Quick Search functionality to find Contacts, Addresses (a custom object we have) and Incidents. Everything works fine if they find…Craig Hevey 28 views 2 comments 0 points Most recent by Craig Hevey Reporting & Analytics for B2C Service
-
Dynamic Search ReportsContent Hello dears, Is it possible to create dynamic search reports? Here is the scenario we are looking to achieve: - User opens the report and gets a filter asking hi…Hanna Abi Akl 34 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Showing avergae amount of days an incident is open before being resolvedContent As the title says really - anyway we can show this? So if we group by hour, how can we see at any hour between the very start and now, how long on average an inc…DigitalWMP_21 34 views 2 comments 0 points Most recent by DigitalWMP_21 Reporting & Analytics for B2C Service
-
Reporting on KB usage across set IP range using clickstreams tableContent Hi everyone I've partially solved this problem, however I hope it can be done easier as currently it completely bogs down my Excel since I have to do a lot of fi…Anthony Smith-114390 47 views 9 comments 0 points Most recent by Anthony Smith-114390 Reporting & Analytics for B2C Service
-
Restart the SLA timestamp when transferring queuesContent Define that the SLA for first response will be 1440 minutes when the ticket is created. I would like that when a ticket is transferred to another queue the time …Leonardo Santos-117785 26 views 5 comments 0 points Most recent by Luis Melo-102111 Reporting & Analytics for B2C Service
-
How can I build a chat "chain of custody" report?Content Hi, I am trying to build a report whereby I can see when a chat request has been declined by one of our agents. So far, I have only been able to find an OOTB rep…James G 27 views 3 comments 0 points Most recent by Kristi Karels Reporting & Analytics for B2C Service
-
If agents don't check 'Send on Save'Content Hi Everyone, I'm new to Right Now. When responding to a guest via email, if 'Send on Save' isn't checked, will a response send to the guest? If not, is there a w…Shelbi Hardin 46 views 4 comments 0 points Most recent by JBaxter Reporting & Analytics for B2C Service
-
Show all requests by category and then by sourceContent Hi, So the report I need has the columns as the the various types of source and the rows are the different categories Category | Total Raised | Percentage of Tot…DigitalWMP_21 27 views 8 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Count time between two dates using a SLAContent Hi, I would like to know how I can calculate a date as SLA calculates the due_date in an incident, but instead of using the incident created date, use a custom d…Guilherme Borges-120430 15 views 2 comments 0 points Most recent by Duncan Taylor Reporting & Analytics for B2C Service
-
Chat Report to show Time when Chatter is waiting for a response from the customer.Content Hello there! Has anyone found or create a report that would detail the time when a chatter is waiting for a response from the customer. I have not been able to f…