Category 276
Discussion List
-
Remove report schedule from user private folderContent I have a few report schedules I would like to delete but the reports are in report private folders that belonged to users who are no longer with us and who's use…User_2025-01-31-02-50-15-254 25 views 3 comments 1 point Most recent by User_2025-01-31-02-50-15-254 Reporting & Analytics for B2C Service -
Find All Invalid Email AddressesContent Hi, I'm looking to build a report so that I can find all invalid email addresses on our contact records. What object will I find this field in? When I'm looking …User_2025-02-03-18-33-06-912 30 views 1 comment 0 points Most recent by Simon Kilgarriff-118560 Reporting & Analytics for B2C Service
-
Calculating Number of Days Between sysdate and Update DateContent Hi all, I have a column in my report to display the number of days between the current date and the date the record was last updated using some report functions.…JoshLong 50 views 6 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Report on concurrent sessionsContent I would like to know the maximum number of concurrent sessions for any given time period. For example, at what time today were the most number of sessions being …User_2025-02-03-20-44-43-163 48 views 2 comments 0 points Most recent by User_2025-02-03-17-17-13-640 Reporting & Analytics for B2C Service
-
Cannot get the custom script to work.Content I've the below custom script, which for some reason is returning the value 0 in the first column of the report. The similar code is in the other report , which w…Farhad Pagdiwala-120269 29 views 2 comments 0 points Most recent by Farhad Pagdiwala-120269 Reporting & Analytics for B2C Service -
Search Knowledgebase UsageContent Is there any way to report the number of times a user uses the Search Knowledgebase tool in the Incident Thread Control? I notice the base report 125 stats do no… -
Toast Notification via ReportContent Hi All, I have a requirement to send toast notification for the Agent while the incident count equals to 1000 via Report for example: I have 3 groups called A, B…User_2025-02-03-19-42-55-164 44 views 1 comment 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
How to use nested logical If() function to show a relevant category value in a column ?Content I have a scenario where I have 3 categories. (Basic, Economy,Luxury) If the value of a column is less than 25 its basic. If value is less than 60, its economy an…Umair Ahmed-122974 59 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Initilisation script not runningContent Hi, Using the code snippet below in the custom script editor of a report, under the initilisation tab, the code doesn't seem to run. Any ideas why? We have sever…User_2025-02-03-19-49-57-702 22 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Dashboard Report Calculation IssueContent Hello, I have multiple reports on my dashboard but having issue with "Incident summary" report. It calculates all statuses of incidents except "Opened" only. I h…User_2025-02-03-20-08-55-527 27 views 7 comments 0 points Most recent by Colby Ross Reporting & Analytics for B2C Service
-
Answer export with list of associated productsContent Hi all, I'm currently having a problem creating a report that shows me ALL of the products associated to a particular knowledge article. When I do an export and …User_2025-02-03-16-29-47-183 37 views 5 comments 2 points Most recent by User_2025-02-03-16-29-47-183 Reporting & Analytics for B2C Service
-
Regarding Action column in ReportContent Hi All, I am totally new to RN Analytics and have a small question regarding the Action column in Report. Actually, I am still on the way of learning Report and …jian gao 56 views 4 comments 0 points Most recent by User_2025-02-03-17-07-58-809 Reporting & Analytics for B2C Service
-
Create to Final Resolved not working as expectedContent Have this column defined as below: sum( if( inc_performance.intv_type = 4, inc_performance.rel_time ) ) I'm hoping it'll show me the time in seconds associated w…User_2025-02-03-19-49-57-702 37 views 10 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Runtime Filter using LogicalContent Hello, This is something so easy in standard SQL but I'm struggling with in OSvC, how do you do multiple logicals for example ((a & b) or (c & d) or (e and f)) ?…User_2025-02-03-17-08-02-219 29 views 13 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
GDPR v Archived IncidentsContent Hi, I am wondering whether anyone is battling the same issues we are. I had a similar topic posted before, was given tips that still require further development,…User_2025-02-03-16-51-39-328 26 views 8 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Time in Waiting StatusContent I have been trying to tweak the report 'Time in Status' shared in the Analytics Cookbook: https://cloudcustomerconnect.oracle.com/posts/217d3f8d00. What I am aft…User_2025-02-03-17-20-20-749 70 views 2 comments 1 point Most recent by User_2025-02-03-17-20-20-749 Reporting & Analytics for B2C Service
-
Time to Resolve, excluding WaitingContent Hopefully I'm just overlooking something simple, but how can I find the total time to resolve a ticket excluding time a ticket was in a status type of waiting? I…User_2025-02-03-21-53-19-701 46 views 5 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Survey Choice Response Rate Exceeds Query SizeContent Hi, I'm using the Report 7032 - Survey Choice Response Rate, and on our Customer Satisfaction survey, which has over 400k responses, I can't pull any information…User_2025-02-03-17-57-37-588 8 views 0 comments 0 points Most recent by User_2025-02-03-17-57-37-588 Reporting & Analytics for B2C Service
-
Concurrency at Interval LevelContent Hi there, I'm having some trouble getting concurrency to calculate correctly at an interval level. If I use the out of the box Chat Concurrency Factor calculatio…User_2025-02-03-22-21-24-745 20 views 3 comments 0 points Most recent by Eleanor Fogg Reporting & Analytics for B2C Service
-
5+ chats abandoned within 30 minsContent Hi, Hoping somebody uses something similar or will know how to proceed. I made a report to show abandoned chats (customer left before agent got engaged) and want…User_2025-02-03-16-51-39-328 25 views 5 comments 2 points Most recent by Amy Nash Reporting & Analytics for B2C Service
-
Audit TablesContent Hello, Hoping someone can add to my list of fields that they use to audit what users in the agent console have done and changed? These are the ones I've used, do…User_2025-02-03-17-08-02-219 54 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report to show incidents that have attachments?Content Hi all, Is there a report available that will show me all incidents that have attachments on them? Or can I do this from a custom report? I've not yet been able …User_2025-02-01-08-29-25-648 30 views 2 comments 0 points Most recent by User_2025-02-01-08-29-25-648 Reporting & Analytics for B2C Service
-
Can RightNow Track All Agents that Responded to a Case?Content For example: Lets say a case comes in by email. Agent A opens the case and send a response. The case is not solved by Agent A and the customer sends another repl…User_2025-02-01-08-29-23-701 26 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Dashboard Styling - Gauge ReportContent Hi all, I was wondering if anyone has any styling tips that they find useful when trying to add a multi-gauge report to a dashboard or in general. I want to give…Colby Ross 43 views 1 comment 1 point Most recent by Mark Kehoe-124305 Reporting & Analytics for B2C Service -
Move row data into columnsContent Hi, I am trying to use the Incident Audit Log as the basis for an incident status progress report and would like to only have one row in the report per incident …Craig Hevey 47 views 5 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
3 responses from staff account in a rowContent Hi, I am trying to count the number of threads from Staff Account (from Threads table) when there was no threads from other users in between (e.g. trying to iden…User_2025-02-03-17-20-20-749 34 views 4 comments 3 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Nancy Franchino 25 views 1 comment 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Showing Unique records count at footer levelContent Hi, I have a requirement to show unique records count at report footer level. i.e Record Count: {NumberOfRecords} The report which customers are using is having …User_2025-02-03-17-37-46-913 35 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Aged Incident after ReassignContent Hello-- I'm looking for a way to have a report where I can have two columns; one showing the age of the incident which I currently have no problem doing, and ano…User_2025-02-03-21-37-51-574 25 views 1 comment 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Incidents with more than one task?Content I'm trying to create a report which counts the number of incidents which have more than one task, grouped by product ID. Outside Service Cloud I'd try to use som…User_2025-02-03-16-58-30-021 18 views 4 comments 0 points Most recent by Simon Kilgarriff-118560 Reporting & Analytics for B2C Service