Reporting and Analytics
Discussion List
-
Register Now! Ask the Experts Webinar: Data ValidationContent Oracle Service Cloud Ask the Experts Webinar Register Now! Validate Data in Your Reports to Ensure the Story You’re Telling is Accurate Wednesday, March 23rd @ 8…Stephanie Kaleva 16 views 2 comments 1 point Most recent by Kenny Tietz-23935 Reporting & Analytics for B2C Service -
Avg Calculation using rel_date_diff functionContent Hi All, I want to calculate average between two dates (incidents closed and incidents created) using rel_date_diff function for excluding holiday and for this I …User_2025-02-03-19-26-48-025 69 views 2 comments 0 points Most recent by User_2025-02-03-19-26-48-025 Reporting & Analytics for B2C Service -
Showing data row wise instead of Column wiseContent Hi Team, I don't know weather this is possible or not in Rightnow. But based on my current requirement I need to know can we show the data rows wise instead of c…User_2025-02-03-19-26-48-025 27 views 1 comment 0 points Most recent by Kenny Tietz-23935 Reporting & Analytics for B2C Service -
Query to display recent itemsContent I need to display top 5 recent items in my custom page. Is there any report available in rightnow through which we can see recent item (like as shown in recent i…User_2025-02-03-17-20-03-936 49 views 1 comment 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service -
Joining Prod-Cat mapping in report with Answers tableContent I have a basic Answers report showing a range answers' selected products and categories. However, I only want the categories mapped to one product to appear in t…User_2025-02-01-08-32-25-828 30 views 5 comments 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service -
How many times an incident was changed to a certain statusContent Hey everyone, I am trying to create a report that shows how many times an incident was changed to a "Waiting" status. Simply put, if the incident was changed fro…User_2025-02-01-08-41-04-877 47 views 7 comments 0 points Most recent by User_2025-02-01-08-41-04-877 Reporting & Analytics for B2C Service -
Report on login user detail on CP sideContent Hi All, I need to show the login user detail at customer portal side,I have attach Report for that. Is I want to apply filter in report or customer portal side. …User_2025-02-03-19-33-02-045 37 views 4 comments 0 points Most recent by User_2025-02-03-19-33-02-045 Reporting & Analytics for B2C Service -
report for open answers survey question with possibility to filter on CSAT questionContent We have created a report that shows us the open answer to our survey (see definition attached). However, we want to be able to filter the results on the results …User_2025-02-03-18-57-47-987 36 views 1 comment 0 points Most recent by Amy Nash Reporting & Analytics for B2C Service -
Report for time assigned to incident queue?Content I am looking to create a report that will show how much time has elapsed between queue transitions. For example, an incident is created and assigned to a L1 queu…User_2025-02-01-08-30-56-379 57 views 1 comment 0 points Most recent by Amy Nash Reporting & Analytics for B2C Service -
Incident Effectiveness ReportContent Hi everyone! I am attempting to build a report that shows the following criteria: Of all incidents CREATED during a date range, how many were marked Solved withi…User_2025-02-01-08-41-04-877 36 views 1 comment 0 points Most recent by Amy Nash Reporting & Analytics for B2C Service -
How to Report on Organization HeirarchyContent Morning everyone! I need to know how I can easily create a report based off of one clients Hierarchy. I have one major client which we will be assisting many of …User_2025-02-03-18-36-38-730 47 views 7 comments 0 points Most recent by Andrew Challis-Oracle Reporting & Analytics for B2C Service -
Report exceeds query size limit.Content I have created a custom chat report using tables Chats / Chat Events / Accounts. The reason the Accounts table is being used is so I can filter by group. I am al…User_2025-02-03-19-39-14-556 63 views 1 comment 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
How to show a calculation output just one time (not in a column for every record)?Content Hi, EXAMPLE: We have a report that has a calculated column of "Total Time" (sum (......)), and another calculated column of "Total Quantity" (another sum (......…David Soto V. 55 views 1 comment 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service -
How to Run Reports when Workspace button is clicked?Content We are trying to simplify the process of sending a report out via email. We are looking to find how we can establish work space rules so when a button is clicked…User_2025-02-03-20-45-37-227 71 views 3 comments 0 points Most recent by User_2025-02-01-08-29-25-648 Reporting & Analytics for B2C Service -
Live Wrap-Up TimeContent I'm trying to create a report that will show what status an agent is currently, if they are in wrap-up mode for any chats and how long they've been in wrap-up mo…User_2025-02-03-20-12-51-730 43 views 10 comments 0 points Most recent by Traci Whitley Reporting & Analytics for B2C Service -
Which date filter to use?Content Hi there I am a little unsure about which date filter to use within one of my reports. I am setting up a scheduled report which will run at 6.00pm daily. But it …User_2025-02-01-08-29-25-648 33 views 1 comment 0 points Most recent by User_2025-02-03-19-34-13-477 Reporting & Analytics for B2C Service -
Organisation hierarchy - how to view all in one report?Content Hi everyone We are trying to clean up and re-organise some of our data (the downside of a data import process) and i would like to see one report where I can est…Nicki Mayers 35 views 2 comments 0 points Most recent by Nicki Mayers Reporting & Analytics for B2C Service -
Multiple calculations for different interfaces in one report - handling timesContent Hi there, I am hoping someone may be able to help me with a report. I have a report which shows me all open incidents by 'brand' - we have separate interfaces fo…User_2025-02-01-08-29-25-648 17 views 3 comments 0 points Most recent by User_2025-02-01-08-29-25-648 Reporting & Analytics for B2C Service -
Restricting Report by ageContent I currently looking at editing the Email by Age report and want to restrict it to only to show incidents that are not solved that are older than 48hours or our S…User_2025-02-03-19-20-38-574 20 views 1 comment 0 points Most recent by Andrew Challis-Oracle Reporting & Analytics for B2C Service -
Notification ScreenContent Hi Gurus, Can we customize the Notification report? Thanks, MohanMohana Gopal S-Oracle 20 views 0 comments 1 point Most recent by Mohana Gopal S-Oracle Reporting & Analytics for B2C Service -
Recent search reportContent Hi All, Please find the attached screenshot.can we remove the recent searches in the Report.? Thanks, MuthuUser_2025-02-03-18-29-17-316 36 views 1 comment 0 points Most recent by User_2025-02-03-19-26-48-025 Reporting & Analytics for B2C Service -
List of reportsContent Does anyone have a list of OOTB reports that we can share with customer ?Niranjan Manohar 45 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
customer thread count when the last status was pendingContent Hello Team, I have to create two column in the same report based on the below condition:- 1. I want to calculate the average time when the status was in pending …User_2025-02-03-19-26-48-025 38 views 2 comments 0 points Most recent by User_2025-02-03-19-26-48-025 Reporting & Analytics for B2C Service -
Is there a way to increase the Text Length Limit beyond 300000 on a Blob?Content I am trying to include the answers.solution field (which is a blob) in a report and it will not let me Save a value higher than 300000 in the Text Length - Limit…User_EEQVS 29 views 2 comments 1 point Most recent by User_EEQVS Reporting & Analytics for B2C Service -
calculate average time between two dates based on statusContent Hi Guys, I want to calculate the average time between two dates based on the status. Don't know how to write correct syntax for that. Please refer the attachment…User_2025-02-03-19-26-48-025 27 views 7 comments 0 points Most recent by User_2025-02-03-19-26-48-025 Reporting & Analytics for B2C Service -
Incident status change following scheduled report? or Timed status change?Content Hi all, I doubt this is possible but thought I would ask. I have a scheduled report that runs periodically, e.g. 10am and 2pm every day. This delivers the report…User_2025-02-01-08-29-25-648 20 views 2 comments 0 points Most recent by User_2025-02-01-08-29-25-648 Reporting & Analytics for B2C Service -
Table containing Open Edit Report configurationContent I need report that describes the Open and Edit parameters of reports per profile. Does anybody know which table contains the open and edit parameters for each re…User_2025-02-03-18-49-47-601 30 views 2 comments 0 points Most recent by Andrew_Irish Reporting & Analytics for B2C Service -
If Incident created due to reply to expired incidentContent In conjunction with my post here https://cloudcustomerconnect.oracle.com/posts/1c3dfa733a, I am trying to find a way to identify incidents that were responded to…User_2025-02-03-19-28-20-911 41 views 2 comments 0 points Most recent by User_2025-02-03-19-28-20-911 Reporting & Analytics for B2C Service -
Weekends on Due Date crosstabContent I'm making a cross tab report that shows the response due for a week. Our SLA doesn't include weekends. In the cross tab, the day of week is showing M-F, but the…User_2025-02-03-18-13-34-376 31 views 2 comments 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service -
Column Sorting by Month, Not YearContent Why will this column sort by month and not year?User_2025-02-03-16-48-16-590 25 views 3 comments 0 points Most recent by User_2025-02-03-20-16-45-224 Reporting & Analytics for B2C Service