Reporting and Analytics
Discussion List
-
Report filter - Case sensitivity for Contacts.loginContent I have a report with a column/filter for contacts.login. Our users would like to search via the filter for the login name with lowercase values but the filter fo…santhosh xavier 36 views 11 comments 0 points Most recent by santhosh xavier Reporting & Analytics for B2C Service -
Report to show Duplicate RecordContent I have custom object employment details linked to contact table using contact id. I want to show only duplicate records in my report.User_2025-02-03-16-53-11-440 55 views 6 comments 1 point Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service -
How to include a count of 0 value in my report.Content I am trying to build a very basic report to set up alerts off of, but struggling with getting values of 0 to show in the report to trigger my alert. The two colu…User_2025-02-03-17-17-13-640 30 views 8 comments 1 point Most recent by User_2025-02-03-17-17-13-640 Reporting & Analytics for B2C Service
-
Including rule state in reportContent Hi there, Please could someone help me with a report, I would like to see all incidents that are currently in rule_state 1 i.e. new incidents. I'm struggling to …User_2025-02-01-08-29-25-648 42 views 10 comments 0 points Most recent by User_2025-02-01-08-29-25-648 Reporting & Analytics for B2C Service
-
Current open time in business days & SLAsContent I know this is far fetched, but was hoping someone had figured out a work around. My business has implemented a new metric where each of our categories of work h…User_2025-02-03-19-30-36-009 42 views 8 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Custom Queue Grouping FilterContent Hi All, I am grouping up incidents created/edited by teams that work different queues, and I have several queues to assign to 8 different teams. I am grouping th…User_2025-02-03-17-07-33-493 30 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Assign to Initial Response IntervalContent Hello everyone, I am trying to reproduce Average time for "Assign to Initial Response" Interval in the attached report. However it is the only column that return…User_2025-02-03-19-48-43-179 42 views 5 comments 0 points Most recent by User_2025-02-03-19-48-43-179 Reporting & Analytics for B2C Service
-
Can we schedule a report to be delivered to FTP server?Content Hi, Is there any option to schedule a report to other than email? I need to deliver a report on a daily basis to FTP server. Can this be achieved? If not FTP, wh…User_2025-01-25-03-58-35-709 44 views 4 comments 2 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
Update Chat records in a report using custom scriptContent Hi All, I am trying to update a chat record using custom script (i am using custom script for the first time) in a report. I am not sure whether there is an Righ…User_2025-02-03-19-25-28-008 45 views 5 comments 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
For the abandoned chat , how can ı get contact id with a custom script?Content Hi, We are required to show contact id's instead of email addresses in our chat report. I created an outer join between chats and contact tables and added contac…User_2025-02-03-19-14-20-726 23 views 3 comments 1 point Most recent by Deniz Dogan Reporting & Analytics for B2C Service
-
SmartSense ReportingContent Hello everyone, We have enabled SmartSense scanning (both Contact and Staff) in our incidents. Have you ever come accross or custom made any reports summing sent…User_2025-02-03-19-48-43-179 45 views 3 comments 0 points Most recent by User_2025-02-03-19-48-43-179 Reporting & Analytics for B2C Service
-
"Date Incident was Escalated" to a queueContent HI All, i am new to OSC so need help. i need to create a report for all the incidents that were escalated and sent to escalation queue. so here are the steps 1Ag…User_2025-02-03-19-31-37-724 25 views 6 comments 0 points Most recent by User_2025-09-05-00-11-37-622 Reporting & Analytics for B2C Service
-
Report " Keyword Search "，the meaning of the filter sourceContent Hi, Everyone When I was using the keyword search report,I found a filter called source that contains options. I don't understand what they mean,Can you tell me? …User_2025-02-03-17-35-30-623 27 views 2 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Issue in Date FilterContent Hi I need to create a report to fetch contact lapsed date is lesser than contact updated date. Lapsed date is custom field of date datatype and contact updated i…User_2025-02-03-16-53-11-440 21 views 13 comments 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
Filter by yearContent Hello, I'd like to offer my users the ability to filter incidents by the year the incident was created. I've figured out how to create a calculated field that sh…User_2025-10-31-01-08-51-703 49 views 2 comments 0 points Most recent by User_2025-10-31-01-08-51-703 Reporting & Analytics for B2C Service
-
Table join on non-primary keyContent Hello, I'm faced with a situation where I need my a report to map a custom field (string) in the incident table to one of 4 categories. There are ~1000 possible …Barry Lanman 31 views 1 comment 0 points Most recent by Justin Beer Reporting & Analytics for B2C Service
-
Parent Incident status with Parent-Child relationContent I have linked incident with parent incident using system attribute called parentincident and give association relation. Report should display the following field…User_2025-02-03-16-53-11-440 75 views 3 comments 0 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service
-
Accessing Filters in a Column DefinitionContent Hi, Please see attached image. We have a report showing a count of incidents in various statuses for an agent. However, what we want to be able to do is for the …User_2025-02-03-19-49-57-702 38 views 2 comments 0 points Most recent by User_2025-02-03-19-31-14-086 Reporting & Analytics for B2C Service
-
Answer Feedback Details (By Answer) - Analytics Cookbook RecipeContent Feedback Details By Answer Author: Joe Landers Difficulty rating: (Basic) Target persona: Business Analyst, Knowledge Administrator, Training Manager Customer fe…Joe Landers 45 views 2 comments 4 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Ability to track customer email notification via reportsContent Hi All, I have a requirement like to track the customer incident email notifications via reports Is there any way to track the customer email notification? Any h…Seethalakshmi S 29 views 3 comments 0 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
Report for workspaces assigned to which profilesContent Is there a report that will provide me with a list of profiles with the workspaces assigned? Thanks!JLFolkman 28 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service
-
Tickets by transactionContent I need to account for the incidents that have passed in a certain queue, I am using the transactions table and the action "queue" and filtering by queue.id But w…User_2025-02-03-17-19-40-969 23 views 2 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
union, join, or transposing field values into a calculated fieldContent Hello, We have the ability to assign several counties to a single incident, as some incidents are about things that affect several counties, for example, a spill…User_2025-10-31-01-08-51-703 32 views 3 comments 0 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service
-
Adding BCC email address to Email response reportContent I'm looking for help to narrow down the Data Dictionary term to add/capture CC and BCC email addresses added to incidents. The normal email term only appears to …User_2025-02-01-08-53-19-096 27 views 2 comments 0 points Most recent by User_2025-02-01-08-53-19-096 Reporting & Analytics for B2C Service
-
How to display a report with data filtered by a custom field?Content I have the contact workspace and added a new field 'Account Number' in the table contact. I have a tab in the workspace where I want to display the data from a c…User_2025-02-03-19-04-27-500 29 views 10 comments 0 points Most recent by User_2025-02-03-19-04-27-500 Reporting & Analytics for B2C Service
-
How do I delete all data from an object/table?Content How do I clear a custom table?User_2025-02-03-19-04-27-500 41 views 4 comments 0 points Most recent by User_2025-02-03-19-04-27-500 Reporting & Analytics for B2C Service
-
How do I order By a particular column in a Report?Content How do I order By a particular column in a Report?User_2025-02-03-19-04-27-500 27 views 2 comments 0 points Most recent by User_2025-02-03-19-04-27-500 Reporting & Analytics for B2C Service
-
Where Clause in Desktop .NET appContent I have to create a report that will need to only list if a contact in a case does not match a contact in an incident. Normally a WHERE clause would look like thi…User_2025-02-03-18-21-36-274 15 views 0 comments 0 points Most recent by User_2025-02-03-18-21-36-274 Reporting & Analytics for B2C Service
-
Answer effectiveness - incidents generatedContent Is there any way to see what incidents are generated after viewing a specific answer? Version 17D (almost 18A)User_2025-02-01-07-03-13-295 17 views 4 comments 0 points Most recent by User_2025-09-05-00-11-37-622 Reporting & Analytics for B2C Service
-
Display/Hide a column based on a conditionContent Hi, Can I display/hide a column based on a condition or conditions? Please note that I am referring to an entire column here and not rows. ThanksLeomar Cortez 40 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service