To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
Disabled Report Link Error when saving a report.Content I was looking at the following recipe: https://cloudcustomerconnect.oracle.com/posts/e767416f65 This looks like something I could really use. Not sure what I am … -
Based on date, value should display in a Report columnContent Hi All, There are two columns in a Report. One is Date column which display date in DD-MM-YYY HH:MM AM/PM format and one is Items column (will display item names… -
Filtering Based on Logged In Account GroupContent Is it possible to filter rows in a report based on the signed in accounts assigned group? My first thought was to use a custom script to get the logged in user i… -
Displaying all rows in aggregate report, even those where count = 0Content Hi there, I have a report that shows me how many incidents of type A are assigned to each account with profile ID of X, filtered by the date range during which t…User_2025-02-03-18-15-18-780 30 views 3 comments 0 points Most recent by User_2025-02-03-18-15-18-780
-
Filtering out from a report any incidents which are not the last (or most recent) incident assigned.Content Thanks in advance for any help - really appreciate it! I have a report that shows me several fields of the last incident related to all of my organisations. To a…User_2025-02-03-18-15-18-780 41 views 4 comments 0 points Most recent by User_2025-02-03-18-15-18-780
-
Showing all related incidents in a reportContent Hi All We have added a incident system attribute so we can relate incidents. As its only a Parent/Child relationship and service cloud doesn't support automatic …
-
Applying a Grouping to a calculated columnContent Hi All, I have a calculated column 'Outcome' based on the values on a text field. I want to group and count the sum based on the Calculated Column 'Outcome'. Any…User_2025-02-03-16-56-54-367 48 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328
-
Applying a Grouping to a calculated columnContent Hi All, I have created a computed column called 'Outcome' based on the values in a text field. I want to now group and count based on the computed field 'Outcome…
-
How to handle Custom reports in CPM?Content Hi All, Is there any way to handle custom reports in CPM? When I query with the report ID am getting only the ID, Name, Created and Updated time. How to get the …
-
Number of chats answered in the Satisfaction Survey reportContent I would like to bring the number of appointments in the Satisfaction Survey report. I currently have filters for: Queue, Date of search response and interface.At…
-
lost inbound emailContent Hi friends ! We have an issue : * A client called us trhought the phone * we created an incident on Agent Desktop * The agent sent a reponse by mail to the custo…User_2025-02-03-17-27-29-599 13 views 2 comments 0 points Most recent by User_2025-02-03-17-27-29-599
-
Getting Clickstream data from our message baseContent Hello - We have a message base/banner on our home page of our knowledgebase site. At this time, the message that is on there has two links that we would like to … -
Number of Incidents with ResponsesContent I've been reporting on response time and incidents with responses (response being when the initial response email is sent). We have changed our reporting methodo…
-
Autopopulate report filtersContent Hi , Can we auto populate the report filters with workspace field values ? Attached the screenshot, where we want to have the value of filter auto populated with…
-
All incidents closed by customerContent How would I get a report of all incidents closed by the customer?
-
How to Search / Export a LogContent Hi, I am wondering whether anyone found a way to search the Log (from the Configuration - Site Configuration - Logs)? For example the Incident Rules Log can be q…User_2025-02-03-16-51-39-328 43 views 6 comments 0 points Most recent by User_2025-02-03-22-23-59-814
-
Format a Custom URL as 'Friendly'Content I have a problem that I think the community can help me solve. I am not sure where it belongs. I have a field on my report, that I build a URL from. It uses a co… -
Answers that errorContent Hi, In Google Analytics I see error ID 1 showing up (Answer no longer available). However, I can't see what answer they were trying to access. I have looked thro…User_2025-02-01-07-03-13-295 22 views 4 comments 0 points Most recent by User_2025-02-01-07-03-13-295
-
Report multiplying data after table joinContent Hi all, firstly I must explain that my knowledge of reporting is very limited so if I am asking a basic question I apologise but I am rather stuck at the moment …User_2025-02-03-22-00-16-925 24 views 1 comment 0 points Most recent by User_2025-02-03-17-57-37-588
-
Contacts DeletedContent Hi, is there any way to obtain those contacts that were deleted from the database? Is there any audith log to look for this in? RegardsUser_2025-02-03-18-08-05-360 18 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328
-
Format Functionality to Export Option of ReportsContent Can't we edit the format section of the Reports when Exported. Usually the font size is low in the Exported Reports. or Can we have any other functionality to in…
-
Average Email response time (From all incoming emails)Content Hey guys, I think I have been going through most topics regarding this topic. However, I am still struggling to find an answer. What I am looing for is: Average …User_2025-02-03-17-17-46-546 35 views 2 comments 0 points Most recent by User_2025-02-03-17-17-46-546
-
Add field to search on 'Private Messages Per Channel Account' reportContent Hi Group, I'm trying to get help with a report (Private Messages Per Channel Account) that, when you right-click on a record, the option to create an incident ap…
-
ROQL: How to use CategoryHierarchyContent I have this: select Category.ID,Category.LookupName, COUNT(ID) as Total from Incident WHERE Source=1017 group by Category.LookupName order by Category.ID LIMIT 2…User_2025-02-03-19-49-57-702 43 views 0 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Count incidents when a date_group and count(*) is usedContent I have a report with 3 columns * DATE - date_group(incidents.created,'YYYY-MM-DD') * SOURCE - incidents.source_lvl2 * COUNT - count(*) So this shows how many inc…User_2025-02-03-19-49-57-702 58 views 5 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
PHP with Cross TabContent Hello All I am using Servicecloud to report on Grant information from a Grant Specific CRM. The Servicecloud reporting is considerably better than the Grant CRM.…User_2025-02-03-16-56-52-129 24 views 0 comments 0 points Most recent by User_2025-02-03-16-56-52-129
-
Including transactions disables report record commandsContent Hi Community! While working on improving the quality of data and reduce the amount of duplicate information in the system I have found that by joining the tasks …
-
How to replicate CASE statementsContent MY Query select Source.LookupName as Source, Incident.CustomFields.c.telephone_call as Telephone ,COUNT(*) from Incident WHERE Incident.StatusWithType.Status.ID …User_2025-02-03-19-49-57-702 25 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Hide row if a column contains a certain valueContent Is it possible to write a script to hide a row if a column contains a certain value? For example I have a report that displays all the cases for a queue but want…
-
Viewing Popular Answers (Report ID 162) in ConsoleContent I'm trying to view the Popular Answers report but no Answers are displayed when I run it. Are CP reports only viewable on a CP Page?User_2025-02-03-18-13-34-376 37 views 3 comments 0 points Most recent by User_2025-01-29-22-08-41-708