Reporting and Analytics
Discussion List
-
Chat Occupancy By HourContent I'm able to create an occupancy report by date and by agent. Before I get too involved creating a formula, does anyone have a template that can report on occupan…Marv Ferrer 35 views 6 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Show Warning Message in ReportSummary Show Warning Message in ReportContent I want show following warning message in my report. I don't want to add any fields into the report. "WARNING! You have logg…User_2025-02-03-16-53-11-440 46 views 18 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Interval based reportSummary Number of incidents in every 30 minutes for a day.Content Hi, I have a query related to number of incidents created in every 30 minutes but what I can see in doc…Ashutosh_86 59 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Display Number as Number in Excel output of BI publisher reportSummary Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that …User_DYMHE 34 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
How to use both SUM and COUNTContent Hi, We have custom field for a contact called department. It's in the format: DEPARTMENT.TEAM I've split this successfully into two columns. The 3rd column does …King Jack 64 views 5 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
account_session_history tableSummary How long is data kept in the account_session_history table?Content Anyone know how long the data is kept in the account_session_history table? Specifically looki… -
Is it possible to show the Report Definition as a report column?Summary Output the report definition as a columnContent I have a report that shows information about reports, such as the Report ID (name), ACID, Owner, Last Run, etc. I…Ken Sands 46 views 4 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report on Report FiltersContent Hi, Is it possible to build a report which shows all the reports and what report filters are used in those reports? Report Link Run Values (ac_rpt_link_run_vals)…User_2025-02-03-17-15-23-653 50 views 2 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
creating historical reports independent of individual column dataContent While creating a report that relies on more than one date column (incidents.created and incidents.closed) to calculate backlog, it didn't appear possible to perf…Edgardo Lineros-Oracle 45 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
contracts approval flow tabelSummary tabel behind the contracts approval history flowContent Hello all, I have to build a report that contains the contracts approval flow information, like in the im…User_2025-02-04-08-34-10-102 43 views 5 comments 0 points Most recent by User_2025-02-04-08-34-10-102 Reporting & Analytics for B2C Service
-
How to check syndicate chat performanceContent Hi, i am working to get all the pages from where Chat Initiated, we are using Conditional Chat and Proactive Chat both. Columns are required : URL from where cha…Ajay Yadav-140866 36 views 1 comment 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
one report as input for another (similar to SQL View)Content Hi all, I have the following challenge: I want to use one report with a group count (e.g. first name, last name, email) to put a count behind, then do a group fi…Kai-Uwe 26 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Expired Incident reference #Content For incidents that are created due to a reply to an old incident that has been closed past it's threshold- Can I create a report that shows the new incident refe…Kim Dante 56 views 5 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Using data_group function to show two separate date formats?Content Hello - I am trying to utilize the data_group function to show two separate date formats within one column, if possible. For example, data would show as Year/Qua…User_2025-02-03-16-45-30-713 56 views 3 comments 0 points Most recent by User_2025-02-04-09-25-45-142 Reporting & Analytics for B2C Service
-
How to get the COUNT totalSummary I need information on how to use the COUNT function in an IF conditionContent Hello, I tell you that I have a column called "Interactions Arrived" that displays …User_2025-02-04-18-19-53-976 74 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
How to Mask Year in Date of BirthSummary Attempting to mask or completely remove year in date of birthContent Hello, I am attempting to produce a report that will give birthdays without year. We have ma…User_2025-02-04-13-00-33-588 81 views 5 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Display Product ID on ReportSummary Display Product ID on ReportContent It is possible to display the product id, not the name, on a report?JLFolkman 50 views 4 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Chat session and skillsSummary Showing chat skills with status detailsContent Hi, Our chat team want a report to see details of agent statuses/availability together with skills. They want to s…User_2025-02-01-07-03-13-295 28 views 3 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Email Notification Rule: Chain - Action IssueSummary Created an email chain rule that should escalate to an action rule. Rule is not escalating properly.Content Hello, I am working on creating a new email rule with…User_2025-02-03-16-45-30-713 45 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Variable as filterSummary How do I make a variable a filter option?Content Hi, We have a lot of languages supported (20+). I have team managers who want to look at a report for say wester…User_2025-02-01-07-03-13-295 83 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Linked Reports in GraphsSummary How do I edit linked reports in graphsContent Hi, There's a report in our solution which appears to have been copied with slight changes from another report offe…Joaquin Ollo 36 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Show the number of logins and the number of incidents at the same reportSummary number of logins and incidents at the same reportContent Hi all, I am trying to display below information in the same page: Account name, number of logins, numbe…User_2025-01-29-21-00-45-554 40 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Custom report extract from Oracle Service CloudSummary Custom report extract from Oracle Service CloudContent Hi There, We have a custom report created in Oracle Right Now which is reading the data from multiple tabl…User_UDK6T 116 views 3 comments 0 points Most recent by User_2025-02-03-23-55-43-518 Reporting & Analytics for B2C Service -
Search stats and clickstream actionsSummary Joining the search stats/keyword searches to clickstream action idsContent We have a requirement to breakdown the searches summary (id 208) and keyword searches …Makarand Malandkar 46 views 0 comments 0 points Most recent by Makarand Malandkar Reporting & Analytics for B2C Service -
Is it possible to search for reports by alerts?Summary Is it possible to search for reports by alert title, subject, or recipient using the Report Management tool or something similar?Content Hello, I am currently tr…User_2025-02-03-17-53-10-691 52 views 2 comments 0 points Most recent by User_2025-02-03-17-53-10-691 Reporting & Analytics for B2C Service
-
Time is calculating even after logging outSummary Time is calculating even after logging outContent Hi I copied the standard report "Incident web visit" and changed the filter to contact.ID and placed in contact…User_2025-02-04-18-40-04-172 30 views 0 comments 0 points Most recent by User_2025-02-04-18-40-04-172 Reporting & Analytics for B2C Service
-
Report to get the informationSummary Report DataContent Hello Team , Is it possible to create a report to get the below mentioned points 1.Tables utilized 2.Whether the report is linked to any analy…Kalpana Rathore-144228 47 views 1 comment 0 points Most recent by LuukS Reporting & Analytics for B2C Service
-
Channel Options in Reporting filterSummary Channel OptionsContent In reporting Incidents.chan_id gives me many options. What is the difference between CSS E-mail & E-mail & MA E-mail?User_2025-02-03-16-53-11-440 51 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Maxed out chatsSummary Report creation for resource allocationContent We are working on resource allocation KPIs and attempting to build a maxed out chats report. To the business, "max…Edgardo Lineros-Oracle 25 views 1 comment 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
How to know the Source URL of the ChatSummary i want to check what was the URL of the page from where chat was initiatedContent I have multiple instances of syndicated proactive chat and syndicated condition…Ajay Yadav-140866 44 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service