Reporting and Analytics
Discussion List
-
How to detect a BOT attack and identify IP addressesContent In May 2016 I noticed an increase in visitor actions/visits when I ran my Service Summary report, ID:36. Oracle technical support responded to my service request…User_2025-02-03-18-33-52-964 74 views 8 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service -
Report showing Duplicate values in a custom fieldContent We have a custom field (orgs.c$accountnumber) that has duplicate values assigned to different customers based on brand and location. I am trying to create a repo…User_2025-02-03-17-15-57-451 40 views 2 comments 0 points Most recent by User_2025-02-03-17-15-57-451 Reporting & Analytics for B2C Service
-
Work Hour Relative IntervalContent Hey awesome people! We have been going on absolute time, and now we are not going to be 24 hours. I need to modify my reports to be in relative time. The only ad…User_2025-02-03-19-20-35-072 28 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report for incidents that are forwarded.Content I have a requirement by which my agent will forward an incident to some email id. After doing this he should be able to track all the incidents with email ids to…Umer 42 views 11 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
PercentagesContent ok, still newbie here! I want to use the report Incidents by Disposition report ID 100140 and add a percentage tab so I can see the percent of each disposition t…User_2025-02-03-19-20-35-072 18 views 2 comments 0 points Most recent by User_2025-02-03-19-20-35-072 Reporting & Analytics for B2C Service
-
Highlight duplicates values in a report if not all columns are duplicatedContent I have a report with, say, 4 columns. Two lines of the data have identical values in 1 column, but not the other columns. I want those two lines to be highlighte…User_2025-02-03-17-31-49-785 33 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Previous Day Reporting - Any Workarounds for Text Box Header Limitations?Content We have many reports running daily that report on previous days data. These reports have to be MANUALLY edited because there appears to be no way to get the prev…Joe P. 23 views 7 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Report to show Chat Agents and the Chat Queues they are assigned toContent Hello - Is there an out of box report that I can use to pull up a list of all Chat Agents and list the Chat Queues each agent is assigned to in their Profile? I …User_2025-02-01-08-18-48-897 32 views 2 comments 0 points Most recent by User_2025-02-01-08-18-48-897 Reporting & Analytics for B2C Service
-
Display Deleted Incidents Report with detailed information such as email, contact name and phone...Content Hello, I was reading the following useful post https://cx.rightnow.com/app/answers/detail/a_id/2460/kw/deleted%20record. I noticed that we can display basic info…User_2025-02-03-19-31-18-902 69 views 6 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Time in Status - Business HoursContent The Time in Status report from the cookbook post https://cloudcustomerconnect.oracle.com/posts/217d3f8d00 is great and have been looking for something like this …Tod 59 views 1 comment 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service
-
Report Column function to calculate days between two datesContent All, As the title suggests, I'm attempting to use functions to calculate days between two dates, however I have not been successful to have the function return t…JoshLong 26 views 6 comments 0 points Most recent by JaneSolihull Reporting & Analytics for B2C Service -
Total surveys sent by monthContent I know how to get total surveys sent, but I'm struggling to break that down by month. Any suggestions?Kim Dante 22 views 16 comments 0 points Most recent by Simon Kilgarriff-118560 Reporting & Analytics for B2C Service -
Fetching Mapped Workspaces for All ProfilesContent Hi, I'm trying to generate a report in Rightnow which shows all the profiles and workspaces mapped to each profile. In that report, I need following 3 details. 1…User_2025-02-03-19-42-36-289 17 views 3 comments 2 points Most recent by Jens Lundell-Oracle Reporting & Analytics for B2C Service
-
Alerts - Only include the last incident that meets the exception criteriaContent Hi, I have created a report that sends an Alert every time a chat goes abandoned. I based it on an exception with the following parameters: Expression: chats.fir…User_2025-02-03-16-51-39-328 23 views 3 comments 1 point Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service
-
How to change the date of the column chat_rt.first_engagedContent Hi guys, I have created a real-time chat report with the "chat_rt" table. The problem I have is that when a client is waiting for an agent to accept the chat inv…Monica Valois 13 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Creating a custom script to remove unwanted dataContent Hi, We have an integration with our ACD that when a phone call is answered by an agent, a customised contact search report is popped in Oracle Service Cloud. The…JamieRobertson33 59 views 1 comment 1 point Most recent by Edson Junior, Oracle Reporting & Analytics for B2C Service -
Alert for Abandoned ChatsContent Hi, I was wondering whether somebody has done anything similar. I have a request to create an Alert every time a chat goes abandoned from a specific queue. The A…User_2025-02-03-16-51-39-328 28 views 3 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Contact audit log report should show all updatesContent For one of the contact, date last updated is today (18/01/2018 03:23). Audit log is not showing that date.(Refer attachment) Contact audit log report is not capt…User_2025-02-03-16-53-11-440 71 views 3 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Get a report which matches multiple criteriaContent I want to get a report of Organizations which have expired on their support contract (SLA instance) last quarter. I do not want the org to show up if they have a…User_2025-02-03-16-35-06-203 20 views 1 comment 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Abandoned Web chat wait timesContent Hi there We are trying to identify how long customers have waited for before abandoning their chats. Can anyone tell me if this can be done and what field/s we'd…User_2025-02-03-16-25-59-941 18 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Database and File Storage report other than VCIOContent Is there a way to report on what is taking up the database and file storage? We can see in the VCIO, but want to know things like what kinds of files (Incident a…User_2025-02-03-18-13-34-376 57 views 3 comments 0 points Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service
-
Chats reportContent Is there a report that shows for hours of the day how many agents were online vs. how many chats were active vs. how many chats were on hold? if it does not exis…User_2025-02-03-17-29-01-634 28 views 1 comment 1 point Most recent by Carl Elliott Reporting & Analytics for B2C Service
-
Proper use of count function on reportsContent I'm facing a problem while building a report . I'm trying to count the total number of chat session a client had with us. This is the report: I tried to create a…Douglas Silva 23 views 8 comments 0 points Most recent by Douglas Silva Reporting & Analytics for B2C Service -
Merging 2 text areas in a report column.Content Hi All I am trying to merge 2 text area fields into one column in a report but I am getting "expecting non-blob, found blob" error. Is what I am trying to do imp…Nigel Oliver 23 views 5 comments 2 points Most recent by Nigel Oliver Reporting & Analytics for B2C Service -
Last Referring URL Report for ChatContent Hey everyone, I am attempting to build a custom report to show the Last Referring URL before a Chat Request. I have built a "referrer" report where I used "click…User_2025-02-01-08-41-04-877 20 views 4 comments 0 points Most recent by User_2025-02-03-20-04-14-449 Reporting & Analytics for B2C Service
-
Changing size of custom fieldContent Hello, In an effort of controlling data quality, we would like to limit a custom field from 255 characters to 10. There is data currently in this field that woul…User_2025-02-03-18-55-26-007 27 views 4 comments 0 points Most recent by Geetha Amrutha Reporting & Analytics for B2C Service
-
I need help calculating with Live Chat reportsContent I am using the chat_queue_stats_rt table, it seems that it is not possible to make calculations with it. I need to have the real-time calculations of a Chat queu…User_2025-02-03-17-19-40-969 29 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Scheduled report only had 10,000 recordContent Hello All, This is the first question on this forum as i am kind of new to Oracle Right Now CRM. i scheduled a report and i was successful in doing it however th…User_2025-02-03-19-31-37-724 40 views 2 comments 0 points Most recent by User_2025-02-03-19-31-37-724 Reporting & Analytics for B2C Service
-
Difference between user_trans and account_session_historyContent I'm doing some reporting on Staff Accounts and noticed that when I report on logins between these two tables, I get some differences. For instance, for Start Dat…User_2025-02-03-18-13-34-376 44 views 6 comments 0 points Most recent by User_2025-02-03-18-13-34-376 Reporting & Analytics for B2C Service
-
Sort Report Roll-ups by Group CountContent Is there a way to sort roll-ups by the group count? It appears that the only options that are available are to sort the roll-ups alphabetically... Alternatively,…User_2025-02-03-23-55-43-518 22 views 7 comments 0 points Most recent by User_2025-02-03-23-55-43-518 Reporting & Analytics for B2C Service